Disaster recovery Code Challenges & Tips

1. Write a SQL query to identify the top 5 tables by total row count in a database to prioritize for backup.

2. Create a stored procedure that performs a point-in-time recovery of a specific table using transaction logs.

3. Write a SQL script to generate a report of all the backups taken in the past 30 days, including the location and size of each backup file.

4. Develop a trigger that logs changes to a specified table into an audit table for disaster recovery purposes.

5. Write a SQL command to restore a database from the latest full backup and the most recent differential backup.

6. Create a script that checks for any orphaned backup files that are older than 60 days and deletes them from the backup directory.

7. Write a SQL query to find the last backup timestamp for each database on a SQL Server instance.

8. Develop a procedure that automates the cleanup of transaction logs based on a specified retention policy.

9. Write a SQL statement that generates a complete script of a specified schema, including all tables, indices, and constraints.

10. Create a batch file or script that replicates a database from a primary server to a standby server, ensuring minimal downtime.