Program Files Microsoft

Sql Server Backup History

SQL Server backup history is a record of all the backup operations that have been performed on the server. This information can be used to troubleshoot any backup or restore problems that may occur.

The backup history is stored in the msdb database. You can view the backup history by using the sys.dm_backup_history dynamic management view. This view contains the following information:

-The date and time of the backup

-The type of backup (full, differential, or log)

-The size of …