Ravi,

Navigate through enterprise manager--> Expand-->select your
db-->right click for particular db--> properties -->go to datafiles
tab--> you will come to know where is datafile located..

Cheers,
Abdul Razaak.M.P.

-----Original Message-----
From: Ravi Kumar
[mailto:oracledba-ezmlmshield-x27872994.[Email address protected]
Sent: Tuesday, October 30, 2007 6:30 PM
To: LazyDBA Discussion
Subject: RE: physical location of Datafiles and logfiles Using SQL
SERVER 2000/2005

Hi Andrews,

I AM ASKING IN SQL SERVER 2000/2005 NOT IN ORACLE 9I..........


Thanks
Ravi



-----Original Message-----
From: Andrews Jain [mailto:[Email address protected]
Sent: Tuesday, October 30, 2007 8:51 AM
To: Ravi Kumar
Subject: RE: physical location of Datafiles and logfiles Using SQL
SERVER 2000/2005

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


In oracle it is V$logfile and dba_data_files.

Regards

Jain Andrews

-----Original Message-----
From: Ravi Kumar
[Email address protected]
Sent: Tuesday, October 30, 2007 6:14 PM
To: LazyDBA Discussion
Subject: physical location of Datafiles and logfiles Using SQL SERVER
2000/2005

Hi Experts





Could you please tell me Command to find the physical location of
Datafiles and logfiles Using SQL SERVER 2000/2005?





Thanks

Ravi









---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





______________________________________________________________________
This e-mail has been scanned by Spam Manager Email Service, using
Skeptic(tm) technology powered by MessageLabs.
______________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


ATTENTION: The information in this email is confidential and may be legally privileged.
It is intended solely for the intended recipient.
Access to this email by any one other than the intended recipient is unauthorised.
In the event you have received this email by mistake you are requested to immediately
inform ING Vysya Life Insurance of the same by forwarding this mail to system.[Email address protected]
and thereafter you are required to delete it from your system permanently.
If you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in connection with it, is prohibited and unlawful.
When addressed to our clients, any opinion or advice contained in this email is subject to the terms and
conditions expressed in any applicable terms of business or client engagement letter issued by ING Vysya Life Insurance.



Oracle LazyDBA home page