Comments posted to this topic are about the item Database Backup Information Scripts
Couple of notes:
1. Besides D and L types of backup, there is also P = partial.
2. It would be also helpful to include database_name in select part of "Most Recent Database Backup for Each Database - Detailed"
Thanks for sharing the script with us. To add to SQL Guy 1's comment, you should also include I (Differential) to backup types. Thanks again.
Nice script, thanks.
One Orange Chip
Hi Satya.. this is excellent script for sharing..
How can I add linked server name in this script for getting backup report in one single format.
I have created linked server, Name is : MNDLIVPROD
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
WHEN 'D' THEN 'Database'
WHEN 'L' THEN 'Log'
END AS backup_type,
--msdb.dbo.backupset.name AS backupset_name,
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7)
Viewing 5 posts - 1 through 4 (of 4 total)