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

These DB's were restored from SQL Server 2000 DB's and have got 3 files:
.LDF
.dt1
.sys

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.
BradyExp1Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
0
 
tigin44Commented:
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
0
 
BradyExp1Author Commented:
Perfect. Attached using the .sys and it worked a treat.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.