mercredi 7 mars 2012 07:19
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
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 ?
- Modifié s sai kiran kante mercredi 7 mars 2012 07:23
Toutes les réponses
mercredi 7 mars 2012 09:29
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.
Regards, Ashwin Menon My Blog - http:\\sqllearnings.com
mercredi 7 mars 2012 09:33
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?