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.

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:

• Overview of Sql

• Sql server while loop

• Continue Statement in sql

• How to Create Sql Function,

• SQLInjection, prevent asp.net web application

• SQL Parameter how to use in asp.net

• SQL-QUERY TYPES, ALIASES, JOINS, CLAUSES, FUNCTIONS

• Sql-determine the version and edition of SQL Server

• Sql -Stored procedure how to use

• Different Types of SQL Server Stored Procedures

• SQL-Create Stored Procedure in SQL Server:

• SQL Server -Create Stored Procedure with Parameter

• Sql server cursor declaration syntax example

• SQLServer questions for interview

• Sql server-How to Optimization cursor

• Interview Part3

• Interview Part4

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:

• Fill data into Dropdown list by using Jquery

• Validate ASP.Net RadioButtonList using JavaScript Example

• Example of jQuery Validate on Radiobuttonlist in Asp.Net using C#

• Example jQuery Validate on CheckBoxList using C#

• Get current datetime in jquery and javaScript

•  Asp.net Digital Clock with jQuery & CSS3

• Check Uncheck all asp.net CheckBox in asp.net using jQuery

• Check Uncheck all html CheckBox controls using jQuery:

• Asp.net CheckBoxList using jQuery.

• Cropping image using jQuery in asp.net

• Displaying the textbox value in javascript Messagebox

• Get selected radio button values using JQuery.

• How do you do html text encodes using JavaScript

• Limit Number of Characters in a TextArea using jQuery

• Limitation of Characters in Textbox or TextArea in asp.netusing jquery:

• jquery disable or Enable submit button after validation

• Enable Disable Submit Button using jQuery

• JQuery UI Datepicker (Calendar) with asp.net textbox