Need to restore db to an instance with a lower version

Question

Hi all
I made backup of db running on a SQL server version 10.4.11. Now I have server with version 10.00.1600 and I cannot restore db?
Is there some plugin that can do this?

Answer 1

Im afraid that this is not possible. You can upgrade your instance to newer version and then do the backup.
Read more here, you are not the only one having this problem :)

Answer 2

You can't.  There is no way to "downgrade" a SQL Server database.

Also, 10.0.1600 is the RTM version of SQL 2008 (non-R2).  This version is not supported and you need to update to the current service pack.

Please see:

http://support.microsoft.com/kb/321185

Answer 3

The only way is to create a script for all objects and use the script to generate database and export all data to lower version.

http://www.mssqltips.com/sqlservertip/2676/export-data-to-an-earlier-sql-server-version/