How do I restore databae

Question

Hi guys,

I have a .bak file exported on sql server 2008 version running on 10.50.1600.

My version is 10.00.5500 

When I try to restore it, it gives me an error saying 

Restore failed for Server 'SAI-PC'.  (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
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.5500. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

I know I can reinstall the sql server 2008. Please dont suggest me that. i have lot of other databases and logins defined in this one.

Are there any other ways I could restore this one ?

Answer 1

There is no way you can restore a backup taken in an earlier version of SQL Server to an older version of SQL Server, which means that a SQL 2008 R2 backup cannot be restored on a SQL 2008 instance.

An option is to script the database from the SQL 2008  R2 and use the script to create database and populate data in SQL 2008. While scripting you have option to script data for SQL 2008.

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 2

Hi,

You can't go backwards in versions. You need to restore the database to a SQL instance that is running 10.50.1600 or later. After that you could do a export/import to the older version, BCP, script objects, etc but that creates a new database with the correct version and then imports the data/objects, etc.

Where did you get this backup from?

---

Sean Massey | Consultant, iUNITE

Feel free to contact me through My Blog, Twitter or Hire Me.
Please click the Mark as Answer button if a post solves your problem!