Multiple choice technology databases

Your database has become damaged. Which of the following can be used to determine which backups can be used to restore the database?

  1. (a) SQL Server error log

  2. (b) msdb.dbo.sysbackuphistory table

  3. (c) Windows Application Event Log

  4. (d) msdb.dbo.backupset table
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

When determining which backups to use for restoration, SQL Server error log (A) contains backup and restore operation messages. The Windows Application Event Log (C) also records SQL Server backup events. The msdb.dbo.backupset table (D) stores complete backup history including timestamps, LSNs, and file paths. The msdb.dbo.sysbackuphistory table (B) doesn't exist - it's actually msdb.dbo.backupset and msdb.dbo.backupfile that contain this information.

Keep practicing — related questions