Friday, February 10, 2012

Cannot find mdf files

I have created a database on SQL Express using SQL Server Manager Express. However, when I try to connect to it in Visual Studio 2005, I cannot find the .mdf file so cannot create the project datasource. Can someone tell me where it is? Searching through the files does not find it. Knowing it cannot be obtained directly and needs to be rebuilt some other way would be helpful.

hi,

the database files you created, if you did not specify alternate positions, usually are in \Program Files\Microsoft SQL Server\MSSQL.[x]\MSSQL\Data ,where [x] is a number representing your database engine instance..

regards

|||Unfortunately, they are not there, at least not with the name I gave it.|||

can u see the database which you created in SSMO. If yes , open a query analyser , and execute sp_helpfile sp to get the physical file of the database. If you can see in SSMO, tell us how you have created the database. Also post the connection string which you use in Visual studio.

Madhu

|||To see the default path where data files are send to, navigate to the properties of the server (in SSMS). there should be an entry for the default storage path which is extracted from the registry.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment