Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Unanswered: How do I open an MDF file?

    I want to start by saying I know virtually nothing about SQL Server.

    I work for a website and have an old database of ours. It was exported in Sql Server 2008. It has 3 files an mdf file, a secondary data file, and a transaction log file.

    When I try to attach I get an error, and the error is 5173 stating "One or more files do not match the primary file or the database." I have looked at the top 20 results for this error in a Google search and have found nothing. I just want to get in and look at some of the data, run a few basic queries. I looked into importing into mysql and that seems like a pain. Any suggestions or ideas?

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Sounds like the file name doesn't match what's in the .mdf header.

  3. #3
    Join Date
    Jul 2013
    Posts
    2
    So how would I look at this? I am just selecting attach and the mdf file, I am never typing anything in.

Posting Permissions

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