locked
tape backups time RRS feed

  • Question

  •  

    How can i get the tape backup time for a database from msdb using Tsql ?
    Monday, July 14, 2008 9:20 PM

Answers

  • The

    Code Snippet

    [msdb].[dbo].[backupset]

     

     

    table has backup_start_date and backup_finish_date information.

     

     

    Monday, July 14, 2008 9:37 PM

All replies

  • The

    Code Snippet

    [msdb].[dbo].[backupset]

     

     

    table has backup_start_date and backup_finish_date information.

     

     

    Monday, July 14, 2008 9:37 PM
  • how do u differentiate between tape backups and disk?

    Is there any parameter difference for this in backupset table?

     

    Monday, July 14, 2008 9:48 PM
  • Thanks, i just altered it to use device type to tape.

    regards

    Monday, July 14, 2008 10:30 PM