• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

system views for backup

how can I check where the backup ran sucessfully or not uisng system views in sql server 2005?
1 Solution
Backup information can be found in msdb.dbo.backupset
See: http://msdn2.microsoft.com/en-us/library/ms186299.aspx

To verify that it ran successfully and the file is not corrupt what I do is run a RESTORE VERIFYONLY statement because even if the backup was successful it is possible that the media or file is corrupt.
See: http://msdn2.microsoft.com/en-us/library/ms186299.aspx

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now