Ahhh, that's a good one. Well, if you must, you can try this URL:
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c04ppcsq.msp x And look at the Attach section about 2/3 they way down... -----Original Message----- From: Charles Nahm [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 09:48 To: SQL Subject: RE: .mdf file - please help this rookie > -----Original Message----- > From: Raster, Tim [mailto:[EMAIL PROTECTED] > 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. Thank you for your quick response Tim. The problem we have is that the current host is being very difficult in their handling of the possible loss of this client and are not being helpful at all. It has been like pulling teeth just to get to this point. If there is any way to work with the MDF, we would like to avoid having to make the client go back and contact the host. > 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. > The client is completely non-technical and in fact has no physical or even remote desktop or terminal service access to the machine hosting the database. Thank you, Charles ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2076 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
