CODEWITHSUNDEEP
sql-server
Myworld
Myworld

Reputation: 1899

Attach SQL Server 2000 database on SQL Server 2005

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

Please anyone advise me.

Upvotes: 1

Views: 2117

Answers (1)

Damien Dennehy
Damien Dennehy

Reputation: 4074

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

Upvotes: 4

Related Questions