Wednesday, March 7, 2012

Can't Re-attach db to a SQL Server 2000 server

Hi,

I had a database running under a SQL Server 2000 server. I detached it and then attached it to a 2005 Server. I the detached it from the 2005 server and tried to re-attach it to the 2000 server. I got this error message:

You can′t. During attaching the database to the SQL 2k5, the internal structure is migrated to SQL Server 2005 specific requirements which are not understandable for the SQL 2000 instance. This is one way only.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment