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 2008 Restore Error

Author  Topic 

xnanx
Starting Member

4 Posts

Posted - 2012-02-22 : 02:37:33
I get this error.
What should I do.
Thank you in advance for your help.


GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-22 : 02:52:56
As the error says, that backup was taken on version 10.50 (SQL 2008 R2) and you're trying to restore it to a lower version (SQL 2008) and that is not possible. Either restore the backup to a SQL 2008 R2 server or you'll need to copy the contents of the database to the lower version (script all objects, export all data, recreate the database on SQL 2008)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -