SQL Server- Database Backup and Restore History

SQL Server- Database Backup and Restore History Tables:

Sql Backup and Restore History Tables:

In this post we consider a list of table that is used to store the backup of database. In my past post we describe many topic related to sql database sequentially by this you can learn and use easily.


SQL Server- Database Backup and Restore History


If you are new in sql data base the we give the list f topics from introduction to create database table, views etc.

Sql Server Related Post:




This Post introduces the history tables that store backup and restore metadata in the  database.

  • Backupfile: Contains one row for each data or log file that is backed up.
  • Backupfilegroup: Contains a row for each filegroup in a backup set.
  • Backupmediafamily: Contains one row for each media family. If a media family resides in a mirrored media set, the family has a separate row for each mirror in the media set.
  • Backupmediaset: Contains one row for each backup media set.
  • Backupset: Contains a row for each backup set.
  • Restorefile: Contains one row for each restored file. This includes files restored indirectly by filegroup name.
  • Restorefilegroup: Contains one row for each restored filegroup.
  • Restorehistory: Contains one row for each restore operation.

JQuery Related other Post:

Comments

  1. Excellent example of how to use backup tables in msdb to get backup history here:
    http://www.sqlhub.com/2011/07/find-your-backup-history-in-sql-server.html

    ReplyDelete

Post a Comment

Popular posts from this blog