Name: backup SQL database set description.Type ,database_name ,server_name ,machine_name from backupset Select name, user_name ,first_lsn ,last_lsn ,database_backup_lsn ,backup_start_date ,backup_finish_date , In this table, we get the information about the logical and physical backup SQL database file name along with the device type in which backup was taken: We can have following values for this.īackup_size: It gives the backup SQL database size in bytes.ĭifferential_base_lsn: SQL Server takes a differential backup for the extents having LSN greater than differential_base_lsn. State: It gives the state information of particular file. Logical_name: Logical name of the database file. We do not have any filegroup for the log file therefore this column can contain NULL value.īacked_up_page_count: It shows the page count backed up.įile_type: We can get the file type using this field. In the following image, we can see essential columns of this table:įilegroup_name: It shows the filegroup name of the data or log file. This table contains the row for each data or log file of the database for which we executed the backup SQL database. In this article, we will understand the way to retrieve the database backup history to meet these critical business requirements.īelow are tables in the msdb database for the database backups.
Do sql backup with valentina studio how to#
In the case of any disaster, we must know exactly how to get the data from this internal table and prepare the restoration plan accordingly. We might be taking different kinds of backups to the main minimum restoration time. SQL Server maintains a backup history in the system database msdb. Such policies help to recover the database with minimum loss of the data and minimum downtime. It is essential for each organization to define the backup policy in its environment. This article will review how to get information on your backup SQL database history, including the metadata in MSDB that can be queried, as well as value-added tools and features to group, sort, report, and export this critical information
0 kommentar(er)
