Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

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

share|improve this question
1  
You need to upgrade the destination server to R2. There's no way around it. – Blorgbeard Feb 24 '11 at 9:43
2  
You cannot move a database from SQL Server 2008 R2 "down" to SQL Server 2008. There's no way, no trick, no workaround - it just doesn't work - you need to move from same version to same version (or up - but you cannot go down) – marc_s Feb 24 '11 at 10:38
Ok how to upgrade the destination server to R2? – Owidat Feb 24 '11 at 12:52

1 Answer

up vote 3 down vote accepted

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.

share|improve this answer
Thanks WraithNath for your fast replay, but there is no way to get or export tables data out of 2008 R2 to 2008? – Owidat Feb 24 '11 at 12:47
Hi Owidat, I hhave never found a way to restore a higher version database to a lower one but if you right click on a database in SQL server you can choose to import data. Then in the wizard specify the server and database to import from. You may be able to import all objects to a new database created on the lower version SQL server. Might take a while to run but I have used this before to copy tables and data from other databases. – WraithNath Feb 24 '11 at 13:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.