I've created a database on SQL Server 2008 R2, but set the version as SQL Server 2005 (90).
When I try to attach this database on a server running SQL Server 2005 (9.00.3042.00), I get the following error:
The database 'MyDataBaseName' cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'MyDataBaseName'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
Can anyone please explain why is this, when the version numbers should be the same? Is there any way to get around this issue please? I've tried different methods (Copy DataBase Wizard, Backup+Restore) but they are failing too.