Sql Server 2008 R2 Restore Issue

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

SQL Server 2008 Forums

SQL Server Administration (2008)

Sql Server 2008 R2 Restore Issue

Author

Topic

ruchir.andharia
Starting Member

2 Posts

Posted - 2011-04-01 : 02:18:11

Hi i have made back up the database from SqlServer 2008 and try to restore that databse into SqlServer 2008R2 , but it give the error.

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.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

can anyone help me ? how i restore databse of Sqlserver2008 to Sqlserver2008R2

Ruchir

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-01 : 02:26:58

Ok it seems that you are restoring backup from higher version to lower version
sql2008(10.50.1600) to sql2008(10.00.1600)
You can export data from your sql2008(10.50.1600) and import in your sql2008(10.00.1600) instance.

Raghu' S

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-04-01 : 05:30:51

quote:
Originally posted by ruchir.andharia

Hi i have made back up the database from SqlServer 2008 and try to restore that databse into SqlServer 2008R2 , but it give the error.

According to the error, you're doing the other way around, from R2 to 2008. Downgrading SQL databases is never possible. Upgrade from 2008 to 2008 R2 is fine, downgrade from 2008 R2 to 2008 won't work.

--
Gail Shaw
SQL Server MVP

ruchir.andharia
Starting Member

2 Posts

Posted - 2011-04-01 : 06:22:43

Hi It works fine. Thanks

quote:
Originally posted by raghuveer125

Ok it seems that you are restoring backup from higher version to lower version
sql2008(10.50.1600) to sql2008(10.00.1600)
You can export data from your sql2008(10.50.1600) and import in your sql2008(10.00.1600) instance.

Raghu' S

Ruchir

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources