Post reply

Count number of trans log backups and find out hanging jobs

  • April 8, 2008 at 1:00 pm

    #71305

    Guys,

    How can I find out "automatically" [i.e. via a query] how many times a transaction log was backed up for a specific database within the last 24 hours?

    Also, how can I find out which jobs are hanging?

    Thank you!

  • April 8, 2008 at 3:17 pm

    #800037

    SELECT * FROM msdb.dbo.[backupset] WHERE database_name = 'databasename' AND TYPE = 'l'

  • April 14, 2008 at 8:29 am

    #802102

    Thanks a lot for the information!

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

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