Attach SQL Server 2000 database on SQL Server 2005

Question

I had MDf Files created with SQL Server 2000 can I attach them on SQL Server 2005 without any problems?

Please anyone advise me.

Yes, the route up in versions (from 2000 to 2005, from 2005 to 2008 etc.) works just fine, no problem at all. You cannot under any circumstances move a database down, however - you cannot attach a database from SQL Server 2005 in a SQL Server 2000 environment. — marc_s
– marc_s, Commented Jun 27, 2010 at 16:08

Damien Dennehy · Accepted Answer · 2010-06-27 11:10:17Z

4

It'll work fine, I've done this a couple of times without any problems.

Just remember if you want to use SQL2005's features on the database, change the compatibility mode from 80 to 90 under the database properties after you attach it.

To do this once the database is running, right-click it, go to "Properties", then click the "Options" menu item on the left, and "Compatibility Level" will appear.

Running the script below will also work.

ALTER DATABASE [Your_Db] SET COMPATIBILITY_LEVEL = 90

edited Jun 27, 2010 at 11:10

answered Jun 27, 2010 at 9:59

Damien Dennehy

4,0742 gold badges21 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Myworld Over a year ago

how can I do changing the compatibility mode from 80 to 90 under the database properties ?

Collectives™ on Stack Overflow

Attach SQL Server 2000 database on SQL Server 2005

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related