Here are the backup and restore system tables and their purpose:
• backupfile – contains one row for each data file or log file backed up
• backupmediafamily – contains one row for each media family
• backupmediaset – contains one row for each backup media set
• backupset – contains one row for each backup set
• restorefile – contains one row for each restored file
• restorefilegroup – contains one row for each restored filegroup
• restorehistory – contains one row for each restore operation
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment