Sql-server – Could not open new database ‘DB Name’. CREATE DATABASE is aborted (SQL Server, Error: 948)

databasesql serversql-server-2008sql-server-2008-r2

*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)

Best Answer

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.

Related Topic