restore backup doesn't work - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

restore backup doesn't work

Author

Topic

sven2
Yak Posting Veteran

57 Posts

Posted - 2010-10-24 : 13:11:39

Hello,

what can i do to avoid the following error that I get when restoring the my database on another server:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

Thanks in advance,
Sven.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-24 : 13:20:44

The backup was taken on a SQL 2008 R2 server. You are attempting to restore it onto a SQL 2008 server. That will not work. Databases can never be downgraded.

You need to restore it to a SQL 2008 R2 server.

--
Gail Shaw
SQL Server MVP

sven2
Yak Posting Veteran

57 Posts

Posted - 2010-10-25 : 10:34:32

Hello,

So what do I have to do to transfer a databse from a server 2008 R2 to another server 2008?

There has to be a way to do this ... or not ?

Best regards,
Sven.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-25 : 10:46:45

Sure there's a way

Script all objects
Export all data
Create a new database on SQL 2008
Run the creation scripts and import all the data.

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-10-25 : 10:51:57

There is an option to Script the DAta with the Objects. Probably not a good idea if there are lots of rows of data, but for small databases it would save a step.

Gawd knows why MS thought it was a good idea to use a "sounds the same" name for the R2 version ...

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-25 : 11:10:13

It's a minor release (like Server 2003 and Server 2003R2) and there were virtually no DB engine changes, just BI addons. However the internal database version changes and hence there's no downgrade for databases.

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-10-25 : 11:24:59

I still think its confusing for the users. Straight version numbers, with point-releases, are easy to understand. SQL 4, SQL6, SQL6.5, SQL7, SQL2000, SQL2005, SQL2008, SQL2008-R2 ... ??

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources