Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 11_1_2_SQLServer_Резервное копирование
- --Набор скриптов для знакомства с SQL Server
- --https://infostart.ru/1c/articles/1128594/
- SELECT @@Servername AS ServerName ,
- d.Name AS DBName ,
- MAX(b.backup_finish_date) AS LastBackupCompleted
- FROM sys.databases d
- LEFT OUTER JOIN msdb..backupset b
- ON b.database_name = d.name
- AND b.[type] = 'D'
- GROUP BY d.Name
- ORDER BY d.Name;
- SELECT @@Servername AS ServerName ,
- d.Name AS DBName ,
- b.Backup_finish_date ,
- bmf.Physical_Device_name
- FROM sys.databases d
- INNER JOIN msdb..backupset b ON b.database_name = d.name
- AND b.[type] = 'D'
- INNER JOIN msdb.dbo.backupmediafamily bmf ON b.media_set_id = bmf.media_set_id
- ORDER BY d.NAME ,
- b.Backup_finish_date DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement