Tag: Backup
-
T-SQL Script to Get Last Backup Dates for All Active DB’s
/* Script to list the last full backup time for all active user DB’s. Version: 2005+ */ with tmp as ( select row_number() over (partition by BS.database_name order by BS.backup_set_id desc) as rowid, BS.database_name, BS.backup_finish_date from msdb.dbo.backupset BS inner join msdb.dbo.backupmediafamily BMF on BS.media_set_id = BMF.media_set_id where BS.type = ‘D’ and BS.database_name not in (‘master’,…
-
Two Quick Tips to Improve Backup and Restore Performance from Brent Ozar
[youtube=http://www.youtube.com/watch?v=NhOK_EujTCU&feature=player_profilepage]