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