An MDF file is a SQL Server datafile. You could try re-attaching it; SQL Server has a method of detaching a database, where the database is removed from SQL Server, leaving the logfile and datafile unattached.
In Enterprise Manager, try going to the Databases folder, All Tasks / Attach database; specify the MDF file, and Attach as a new database name, and set database owner (generally "sa" or some other login that will be registered as the new database's dbo). - David On Thu, 23 Dec 2004 10:34:14 -0500, Charles Nahm <[EMAIL PROTECTED]> wrote: > 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 - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2090 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
