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

Posted on 2010-01-07
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

    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 142

    Accepted Solution

    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

    Perfect. Attached using the .sys and it worked a treat.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now