CODEWITHSUNDEEP
sql-serverbackuprestore
manoj kumar singh
manoj kumar singh

Reputation: 791

Backup in not getting restore

I have taken a backup from a database(Sql server 2008 R2).But in machine i have

Sql server 2008.When i am trying it to restore that backup in machine then it is

showing Error.Following is the error message==

The database was backed up was running on a server running version 10.50.1600.

That version is incompatible with the server which is running on version

10.00.1600. So,how can now i restore my file

Upvotes: 0

Views: 118

Answers (1)

Alaa.Ali
Alaa.Ali

Reputation: 1202

You can not restore a later version backup to a previous version. SQLServer 2008 R2 is the later version. Your Alternative is to script out all data and database objects and run those scripts on SQL 2008. How to Script out your database

Upvotes: 1

Related Questions