Posted by Erland Sommarskog on 01/19/08 15:08

Y?lmaz (ozturkyilmaz@gmail.com) writes:
> I need to learn where mssql server stores its data. I knew it was in
> Program files\Common files\
> But I cant find.. Its urgent pls..

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@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SELECT * vs SELECT col1, col2
• Prev in forum: Re: I need to know where mssql server stores its data.
• Thread view: Re: I need to know where mssql server stores its data.

[Reply to this message]