July 28, 2014 at 4:20 am
Hi All,
If I want to check the 7 Days backup status means how can i check?
Regards
Jagadeesh...
Regards
Chowdary...
July 28, 2014 at 9:24 am
You can query the BackupSet and BackupMediaFamily tables in the msdb database:SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
bu.database_name,
bu.backup_start_date,
bu.backup_finish_date,
bu.expiration_date,
CASE bu.type
WHEN 'D' THEN 'Full'
WHEN 'L' THEN 'Log'
WHEN 'I' THEN 'Diff'
ELSE bu.type
END AS backup_type,
bu.backup_size,
bm.logical_device_name,
bm.physical_device_name,
bu.name AS backupset_name,
bu.description
FROM msdb.dbo.backupmediafamily AS bm
INNER JOIN msdb.dbo.backupset AS bu ON bm.media_set_id = bu.media_set_id
WHERE (CONVERT(datetime,bu.backup_start_date, 102) >= GETDATE() - 7)
AND bu.type <> 'L'
ORDER BY
bu.database_name,
bu.backup_finish_date
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2014 at 10:28 am
Thanks MyDoggieJessie, I hope this answered Chowdary's question. I found the information handy.:-)
July 29, 2014 at 5:22 am
Thank you so much dear MyDoggieJessie....
Regards
Chowdary...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply