Member Avatar for Richard_32

Hello everyone,
I need to open mdf file but I can't install SQL server. Please advise how to view data in sql mdf file?

Thanks in advance,
Richard

  • 3 Contributors
  • 4 Replies
  • 1K Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Richard_32
Member Avatar for rproffitt

This question is usually from a shill. It's not as if there are priors here.
https://www.google.com/search?q=I+need+to+open+mdf+file+but+I+can%27t+install+SQL+server.+Please+advise+how+to+view+data+in+sql+mdf+file%3F&ie=utf-8&oe=utf-8

You may want to read your server's disaster plan. That is, if you ran a server, you as a professional would have a plan for when the server melts down. Time to get out your plan or if there is none, consider this the lesson why your next server will include the disaster plan.

Member Avatar for Richard_32

Thanks for answer

Member Avatar for Stuart_4

It is possible that the database no longer exists or is part of a database mirror. To avoid the error log on as a user who can modify logins. Then, change the user's default database to a database that is currently available for a connection. If it useless try this application MDF Viewer Tool
https://www.viewertool.com/mdfviewer.html

Member Avatar for Richard_32

I want to say thank you for taking the time to share how to solve my problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.