Home Forums SQL Server 2008 SQL Server 2008 Administration Upgrade Database from SQL Server 2005 to 2008 R2 using Restore w/StandBy RE: Upgrade Database from SQL Server 2005 to 2008 R2 using Restore w/StandBy

  • November 12, 2012 at 1:29 pm

    #1558306

    You have to recover the database to allow the upgrade to complete. You could however immediately set the database to read-only.