I have a database sitting on a SQL Server 2008 installation (10.50.1600). I have a need to take a backup copy of this database and restore it to a different SQL Server 2008 installation (10.0.5512), but when I try to do so using the Restore Database wizard I get the following error:
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.5512. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Is there a standard upgrade path that would get me from 10.00.5512 to 10.50.1600, and if so can someone tell me what it is? Alternatively, is it possible to back the database up in such a way as to be able to use that backup on the 10.0.5512 box?