Posted on 2010-01-05
Last Modified: 2012-05-08
Hi, I have two MDF file that I cannot find the databases which are associated with them,do you know what databases are these or how to go about finding them:

Question by:vera2006
    LVL 30

    Assisted Solution

    by:Reza Rad
    you can attach them in sql server and see whole tables and database objects
    LVL 4

    Assisted Solution

    MSSQLSYSTEMRESOURCE - All system stored procedures, views and functions are stored here.
    DISTMDL- SQL server system file used for  distribution database and in replication.

    LVL 5

    Assisted Solution

    I only know it the other way round from db to the files behind it:

    Run SQL Procedure sp_helpdb without parameters to get list of db names

    Run SQL Procedure sp_helpdb <dbname> for each db to get details about the attached files.
    LVL 13

    Assisted Solution


    This corresponds to Resource database in sql server 2005/2008. This is very critical and is required for sql server running on your machine. You cannot/shouldnt delete this data file as it is internally used by sql server.
    Please refer link - for more details.


    This corresponds to Distribution database and will be used by sql server when replication is being set up.

    Hope this helps!

    LVL 13

    Accepted Solution


    Adding to the above info, you can delete the above data file if you dont have any plans in future for setting up replication.
    LVL 7

    Assisted Solution


    is something similar to model database but used for replication distribution database. don't delete it because some SPs will need it, and will fail if wouldn't be able to find it.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    745 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

    13 Experts available now in Live!

    Get 1:1 Help Now