This is the default path. The default folders for data and log files can be
changed using Enterprise Manager/SQL Server Management studio. Also, the
default location can be overriden for individual database files.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Yýlmaz" <ozturkyilmaz (AT) gmail (DOT) com> wrote

On 19 Ocak, 16:11, "Yýlmaz" <ozturkyil... (AT) gmail (DOT) com> wrote:
I think I found it..
Program files\MS SQL\Data\

Y?lmaz (ozturkyilmaz (AT) gmail (DOT) com) writes:
You can use sp_helpdb to locate the files for a certain database.

Now, I'm a little nervous why you would need to find them. Usually there
is little reason to look at the files as such.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Or, if the DB server has failed,

try searching for *.MDF and *.LDF.

(though it's entirely possible the creators gave the files non-standard
extensions.)




--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html