August 18, 2010 at 6:31 am
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
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
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply