0

I have several .mdf files from Snap Survey (v10.0 or lower) but could not open them by SSMS or any .mdf viewer softwares.

Thanh Nguyen
  • 712
  • 6
  • 5
  • To use `.mdf` files, you must have an instance of **SQL Server** installed where you can attach the `.mdf` to - once you've done that, **then** you can look at the contents of the database in SSMS – marc_s Sep 26 '16 at 08:14
  • The problem is that the .mdf can't be attached, SSMS says the file is not a primary database file, or corrupted. – Thanh Nguyen Sep 26 '16 at 08:22
  • You can never attach a `.mdf` from a newer version of SQL Server to an older instance. Can you find out which **version** of SQL Server that "Snap Survey" software is using to create its `.mdf` files?? Or possibly that file is really corrupted - then you're out of luck, basically – marc_s Sep 26 '16 at 08:28

1 Answers1

1

If I'm not mistaken a MDF file is a database file. You can connect to it using a SQL Connection. You can read how to do that over here: How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?

Community
  • 1
  • 1
Luud van Keulen
  • 1,204
  • 12
  • 38