SQL Server provides a number of ways to check the status of your backups, including the following:
• Backup Status Viewer
• sp_help_backup
• sys.database_files
• DBCC INPUTBUFFER
The Backup Status Viewer is a graphical interface that you can use to check the status of your backups. To open the Backup Status Viewer, click the Backup Status Viewer link on the Backup and Restore page in Server Manager.
The sp_help_backup procedure provides information about the backups that are stored in …
