locked
tape backups time RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

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

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    The

    Code Snippet

    [msdb].[dbo].[backupset]

     

     

    table has backup_start_date and backup_finish_date information.

     

     

    Monday, July 14, 2008 9:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks, i just altered it to use device type to tape.

    regards

    Monday, July 14, 2008 10:30 PM