I want to check the 7 Days backup status...

  • Hi All,

    If I want to check the 7 Days backup status means how can i check?

    Regards

    Jagadeesh...

    Regards
    Chowdary...

  • 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

  • Thanks MyDoggieJessie, I hope this answered Chowdary's question. I found the information handy.:-)

  • 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