I need to know where mssql server stores its data.

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

Re: I need to know where mssql server stores its data.

On 19 Ocak, 16:11, "Y=FDlmaz" 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\

Re: I need to know where mssql server stores its 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" wrote in message
news:0553fa11-717b-4e4d-a330-2059dd8ae8a6@e4g2000hsg.googleg roups.com...
On 19 Ocak, 16:11, "Yýlmaz" 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\

Re: I need to know where mssql server stores its data.

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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: I need to know where mssql server stores its data.

"Erland Sommarskog" 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/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