Results 1 to 2 of 2

Thread: t-sql statement

  1. #1
    Join Date
    Sep 2009
    Posts
    4

    Unanswered: t-sql statement

    I'm auditing a sql server instance that has like 100 databases in it - looking for last transaction log backup info. I know I can look under properties to find out for each db

    Does anyone have a t-sql statment for sql server 7 to find the last trans backup for all databases on the instance?

    Thanks a bunch...

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    look in table msdb..backupset

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •