Home / server / Questions / 92061
Accepted
Colin Desmond
Asked: 2009-12-09 02:45:15 +0800 CST

Where does SQL Server store the MDF file paths?

  • 772

As the title suggests, where does SQL Server store the paths to the MDF files it will load at start up.

Our SQL Server is trying to load a file that is not there, reporting errors in the log, but failing to show the database in the treeview of Management Studio. So what I want to do is edit the table(?) that tells it to try and load this file at start-up, thus not creating the database. This will allow me to recreate the DB.

sql-server

2 Answers

  1. Best Answer

    MSSQL 2005 stores the MDF locations within the system database "Master"

    use master
    select name,physical_name from sys.master_files
    go

    http://support.microsoft.com/kb/224071

    • 2

  2. SQL Server stores the settings you're looking for, in the SQL Server Configuration Manager. Check out the Startup Parameters on the Advanced tab for MSSQLSERVER.

    Incidentally, if you are talking about a non-system DB, then you should be able to get SQL Server up and running, and then use the Management Studio to detach DBs that aren't loading up, then reattach them manually.

    • 0