Post reply

backup timings

  • August 21, 2012 at 1:03 am

    #280379

    i need to gather info about the backup schedule timings which are scheduled on sunday from the last 3 month s, can any one send the script of hoe to do this

  • August 21, 2012 at 2:01 am

    #1527975

    The backupset table in MSDB would hold what you want.

  • August 21, 2012 at 5:56 am

    #1528069

    I'm not quite sure what backup schedule timings means. Are you talking about duration of the backups? Are you talking about how often the backup reoccurs? Are you talking about the time the backups actually start?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • August 21, 2012 at 8:56 am

    #1528166

    Try this script, it states the start and end timestamp of each DB backup

    USE [msdb]

    GO

    SELECTrs.[destination_database_name],

    rs.[restore_date],

    bs.[backup_start_date],

    bs.[backup_finish_date],

    bs.[database_name] AS [source_database_name],

    bmf.[physical_device_name] AS [backup_file_used_for_restore]

    FROM[dbo].[restorehistory] rs

    JOIN[dbo].[backupset] bs

    ON rs.[backup_set_id] = bs.[backup_set_id]

    JOIN[dbo].[backupmediafamily] bmf

    ON bs.[media_set_id] = bmf.[media_set_id]

    ORDER BY rs.[restore_date] DESC

    GO

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply