Home Forums SQL Server 2008 SQL Server 2008 High Availability Best practice to setup a test server to restore backups from production automatically? RE: Best practice to setup a test server to restore backups from production automatically?

  • October 23, 2013 at 10:33 am

    #1661023

    joshd 1807 (10/23/2013)

    The databases are fully functional and aren't restoring any logs, so the error message is confusing.

    That message is from the RESTORE DATABASE ... WITH RECOVERY line. Since the restore that would have left the DB RESTORING failed, the attempt to bring it online would fail because the DB's in the wrong state.

    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