Yikes. MDFs are the data files in their native format. It is not advised to try to move those from server to server. It would be better for them to create a backup of the database, which copies the contents into a (usually) .BAK file. Then you would "restore" this .BAK file to an empty database on your server. SQL2k can read SQL7 .BAK files just fine.
All he has to do is right-click on the database in his Enterprise Manager, hit Backup, and tell it where to put the .BAK file. Simple. -----Original Message----- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 09:34 To: SQL Subject: .mdf file - please help this rookie Hello, I am an SQL rookie. We have received an .mdf file from a client that is used in conjuction with a photo hosting website. Judging from data we received, we think it could be MSSql7. We are using MS Sql 2000. We cannot be sure of the version as the client doesn't know either. Are there any conversion tools available, or in the case of a possible file corruption, are there any SQL database recovery specialists that we can hire to get at this data? Thank you very much, Charles Nahm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2073 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
