Home Forums SQL Server 2008 SQL Server 2008 - General SQL Serevr 2008 R2 - All database's restoring.. after transaction log backup RE: SQL Serevr 2008 R2 - All database's restoring.. after transaction log backup

  • April 21, 2011 at 5:50 am

    #1314433

    What's the exact command you are using for the log backups?

    I'm going to guess that you are doing this:

    BACKUP LOG ... WITH NORECOVERY

    That will back the log up, then take the database into a restoring state. It is not a normal log backup command, it's a tail-log, used only for when you are just about to restore the entire database from a backup.

    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