Posted by Greg D. Moore \(Strider\) on 01/19/08 15:40

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9A2AA5BA8E3DYazorman@127.0.0.1...
> 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.

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.)


>
>
> --
> 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



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

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

[Reply to this message]