Could not open new database 'DB Name'. CREATE DATABASE is aborted (SQL Server, Error: 948)

Question

*Hi,

The Case:

I am trying to move a database from one server to another, source server has SQL Server 2008 R2, destination server has SQL Server 2008.

I copied the .mdf file only I tried to use query sp_attach_db and wizard attach but the was an error, as follows:

Attach database failed for Server 'SERVER_NAME'. (Microsoft.SqlServer.Smo)

----------------------- ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

The database 'DB_Name' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'DB_Name'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

Answer 1

I dont think its possible to attach a database from a higher version of SQL server to a lower version.

Eg 2008 to 2003 is not ok,

going from 2003 to 2008 is ok.

You could try doing an import export data but I have not worked out how to attach it so far.