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
Hi,

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.

Regards,
Rob.
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.