Post reply

log backup chain

  • December 23, 2011 at 7:59 am

    #253924

    I want find the log backup chain for any database is ok or broken .

  • December 23, 2011 at 8:02 am

    #1425185

    Select last_log_backup_lsn from

    sys.database_recovery_status where datbase_id=db_id('dbname')

    if its null then No log backup exists

    java[/url]

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

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