• WilliamB (8/12/2009)


    Similar problem here, I need to find out if the database logs will indicate that a database has been recovered and I need to show the log as proof to business.

    If you're looking for info on whether a database has been restored from backup, that info should be in the SQL error log, not the transaction log.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass