Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Question Unanswered: 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?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •