Post reply

Upgrading a DB from SQL 2005 to SQL 2008 and using Recovery

  • January 13, 2011 at 12:38 pm

    #148196

    Hello -

    Here is my dilemma. I have some rather large Sharepoint databases that I need to move to a new server. The old server is SQL2005 and the new one is SQL2008 R2. I know that the restore will automatically upgrade the database. To minimize the downtime of the database I wanted to take a backup, restore it on the new server and leave it open to apply tran logs later. Does anyone have any suggestions on the best way to do this?

    Thanks in advance!

    Mike

  • January 13, 2011 at 1:14 pm

    #1273260

    Restore the backup WITH NORECOVERY. Then you can restore additional log backups, when you have restored the last log backup that you need to, run the command to recover the DB:

    RESTORE DATABASE <dbname> WITH RECOVERY

    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

  • January 13, 2011 at 1:32 pm

    #1273267

    Thanks Gail!

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

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