Mdf file extension in sql 2005

Viewed 33k times. Where does a default installation of SQL Server store these? Add a comment. Active Oldest Votes.

Sam Sam 7, 7 7 gold badges 46 46 silver badges 60 60 bronze badges. SLaks SLaks k gold badges silver badges bronze badges. SQLMenace: But that's not a default installation. Sometimes you can't look at the properties if one of the systems files is corrupt. JBrooks JBrooks 9, 2 2 gold badges 26 26 silver badges 31 31 bronze badges. Gaurav Gaurav 7 7 bronze badges. Byron Whitlock Byron Whitlock Sign up or log in Sign up using Google.

Sign up using Facebook. Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. See wikipedia. A database may also use secondary database file, which normally uses a. As John S. This is because. To illustrate this, if someone wanted to create their primary data file with an extension of. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. What is an MDF file? Asked 12 years, 5 months ago. Active 5 years, 6 months ago. Viewed k times. Viewed 2k times. I would like to accomplish any one of the following options: Attach the database without data loss unlikely but would save me some time.

What SQL commands can I try to get my database going again? Improve this question. I don't see anything Add a comment. Active Oldest Votes. Improve this answer. Kenneth Fisher Kenneth Fisher Slight correction: you will not be able to recover anything that has not been committed and checkpointed to the data file. There's no guarantee that you have a physically or logically consistent database if you don't have the transaction log.

It's probably better than nothing, though. Excellent point. And a backup would be a much better solution, but you do what you can. Ahag Nybiym Ahag Nybiym 1. Mark Willium Mark Willium 1. Sign up or log in Sign up using Google. Sign up using Facebook.