By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,576 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,576 IT Pros & Developers. It's quick & easy.

Move MDF From 2005 Back To 2000

P: 72

Apparently, even if you set the database type to 2000, when you create a database in 2005, it is marked as 2005 regardless, and you cannot then mount the files on a 2000 installation.

This is also apparently true of any 2000 MDF that you attach to a 2005 server, change some data, detach and try to re-attach to the original 2000 server. The files get flagged as 2005.

Is there any way to re-attach a MDF file to a 2000 installation after they have been manipulated on a 2005 installation?

There's nothing being added or removed in terms of SQL objects that are not already in the database files, just some data manipulation happens.

Apr 16 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.