Monday, March 19, 2012

open mdf files w/out sql server

I am trying to assist a client who had a sql server app on a computer that crashed. All that is left is the MDF files.
Is there anyway to open/ export these files without having SQL server?No, but assuming that the MDF and LDF files are small (less than 2 Gb), you could install MSDE 2000 or SQL Express 2005, either of which are available at no charge and would allow you to at least read the files.

Beware, an MDF by itself is a dangerous thing... Be very careful that you understand what you are doing, since it is very easy to get the wrong answer quickly when you're only playing with half a deck... The MDF and LDF files form a working pair in SQL Server. It is dangerous to work with just one of them.

-PatP

No comments:

Post a Comment