Hello,
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..

Thanx

On 19 Ocak, 16:11, "Y=FDlmaz" <ozturkyil... [at] gmail.com> wrote:
> Hello,
> 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..
>
> Thanx

I think I found it..
Program files\MS SQL\Data\

> I think I found it..
> Program files\MS SQL\Data\

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.com> wrote in message
news:0553fa11-717b-4e4d-a330-2059dd8ae8a6 [at] e4g2000hsg.googleg roups.com...
On 19 Ocak, 16:11, "Yżlmaz" <ozturkyil... [at] gmail.com> wrote:
> Hello,
> 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..
>
> Thanx

I think I found it..
Program files\MS SQL\Data\

Y?lmaz (ozturkyilmaz [at] 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 [at] sommarskog.se

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

"Erland Sommarskog" <esquel [at] sommarskog.se> wrote in message
news:Xns9A2AA5BA8E3DYazorman [at] 127.0.0.1...
> Y?lmaz (ozturkyilmaz [at] 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 [at] sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/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