Restore Deleted Databases Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Backup and Restore

What you'll be asked

  1. Which of the following is the first step you should take immediately after discovering a production database has been accidentally deleted?
  2. When restoring a database to a point-in-time, what is the primary requirement for the transaction log backups?
  3. You are restoring a database that was deleted. You have a full backup from Sunday at 12:00 AM and transaction log backups taken every hour. The deletion occurred at 2:30 PM on Monday. Which backup files are required to restore the database to 2:15 PM on Monday?
  4. What is the purpose of performing a 'Tail-Log Backup' before restoring a database that has been dropped or corrupted?
  5. If you are using a cloud-based managed database service (e.g., AWS RDS or Azure SQL) and the database is deleted, what is the most common mechanism used to restore it?

Answers and explanations come after you submit.