Search code examples
databasesql-server-2005mdf

Where does SQL Server 2005 keep the .mdf files?


I'm upgrading from SQL Server 2005 to 2008. I've detached the database I need, but can't find it on the file system.

Where does a default installation of SQL Server 2005 store these?


Solution

  • You can also use management studio to look at the properties>files of any database - that will show the files and their growth settings.