where is the default location for all databases in sql server

Question

I'm trying to find the default location for all my local databases using sql server. Does anyone know?

Answer 1

Info here.

For you it should be \Program Files\Microsoft SQL Server\MSSQL.90\MSSQL\Data\

Answer 2

try this exec dbo.sp_helpdb <db_name>;

if all you need is the files, use short one as use <db_name> exec sys.sp_helpfile;

Answer 3

For SQL Server 2005 / 2008 it should be somewhere like C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA.

Search C:\Program Files\Microsoft SQL Server for .mdf files.

Answer 4

do you mean the location of the .mdf and .ldf files? for sql server 2008 on my machine those default to:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA