Post reply

Any way to restore a backup made Sql Server 2008 R2 to Sql Server 2008?

  • August 18, 2010 at 6:31 am

    #225969

    I'm a developer, not a DBA, working on a DR solution to back up a client's website site and data to server that our company hosts for disaster recovery. I've got the scripts and programs working that do the backups, zip them up, transfer them, and then the restore, but I ran into a hitch while testing. The server I'm using to act as the "client" is running Sql Server 2008 R2, and I'm using my laptop as the "DR" server, which is running Sql Server 2008. The restore fails because of incompatibility of versions.

    Any way around this?

  • August 18, 2010 at 6:46 am

    #1208438

    nope. you cannot go backwards in versions. you would have to do 'logical' restores on a object by object basis.

    suggest you make your DR version the same as the live.

    ---------------------------------------------------------------------

  • August 18, 2010 at 8:19 am

    #1208513

    You must have your DR version at SQL Server 2008 R2. It is an upgrade from SQL Server 2008. You can have a second instance on your laptop with this version for testing.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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