Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 where are sql databases stored to?

Author  Topic 

jamie123
Starting Member

15 Posts

Posted - 2009-04-03 : 01:06:48
This is really dumb, and I know, but I can't find anywhere online that tells me where mssql databases created with sql management studio sql server 2005 are stored. i just created a database and am trying to add it in vs2008, but can't find it,a nd yes I checked C:\Users\myname\Documents\SQL Server Management Studio Express\Projects

any help would be appreciated, thanks!

ashishashish
Constraint Violating Yak Guru

408 Posts

Posted - 2009-04-03 : 01:36:43
i think here u find your LDF and MDF files of SQL SERVER DATABASE....
May be i get u correct

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Thanks..
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-03 : 03:00:29

EXEC sp_helpfile 'db_name'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -