Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Monday, November 3, 2014

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:

1 comment:

  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