![]() ![]() WHERE bs. Magnetic tape backup best practices commonly cover the following areas: care and handling of magnetic tapes, storage environment, magnetic tape backup inventory, backup strategy, and the role of employees. LatestBackupLocation = bf.physical_device_name,īackup_size_mb = CONVERT(decimal(10, 2), bs.backup_size/1024./1024.),Ĭompressed_backup_size_mb = CONVERT(decimal(10, 2), bs.compressed_backup_size/1024./1024.),ĭatabase_backup_lsn, - For tlog and differential backups, this is the checkpoint_lsn of the FULL backup it is based on. WHEN 105 THEN 'A permanent backup device'īackupFinishDate = bs.Backup_Finish_Date, WHEN bs.type = 'Q' THEN 'Differential partial' WHEN bs.type = 'G' THEN 'Differential file' WHEN bs.type = 'F' THEN 'File or filegroup' WHEN bs.type = 'L' THEN 'Transaction Log' WHEN bs.type = 'I' THEN 'Differential database backup' SELECT bs.database_name,ĪND bs.is_copy_only = 0 THEN 'Full Database'ĪND bs.is_copy_only = 1 THEN 'Full Copy-Only Database' ![]() The following query returns successful backup information from the past 2 months. To reduce the number of rows in this table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure. RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header. Can be NULL.ĭuring an msdb upgrade, this value is set to NULL. Major version number of Microsoft Tape Format used to generate this media set. The value for Microsoft SQL Server is hexadecimal 0x1200. Identification number of the software vendor that wrote the backup media label. Name of the backup software that wrote the media label. Can be NULL.įor more information, see MEDIANAME and MEDIADESCRIPTION in BACKUP (Transact-SQL). Number of media families in the media set. All Microsoft SQL Server media sets have a UUID.įor earlier versions of SQL Server, however, if a media set contains only one media family, the media_uuid column might be NULL ( media_family_count is 1). This table is stored in the msdb database. ![]() Applies to: SQL Server Azure SQL Managed InstanceĬontains one row for each backup media set. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |