[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


MY SQL Server 2005 DB's have no .MDF file

Posted on 2010-01-07
Medium Priority
Last Modified: 2013-11-05
These DB's were restored from SQL Server 2000 DB's and have got 3 files:

but there is no .MDF present.

Is there any way I can resolve this so I can attach and detach these DB's. Also will this be causing a performance hit? They all seem to be working fine.
Question by:BradyExp1
LVL 26

Expert Comment

ID: 26198722
Probably the mdf file is located in another location.
right click on the database and choose properties.
Navigate to the files and find out the location of your mdf file
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 26198805
note: the database file endings do actually not matter, you can use ANY file extension when creating database/files.

I will presume, based on the endings, that:
.sys is the main database data file (PRIMARY filegroup)
.dt1 is a secondary file, possibly another filegroup (DT1 ...)
.ldf is the transaction log file.

you should be able to attach using the sp_attach_db stored procedure giving the 3 files

Author Closing Comment

ID: 31673939
Perfect. Attached using the .sys and it worked a treat.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question