<div>
Thanks guys. Both solutions are valid.
</div>


<div>
I think <br />
<br />
select * from sysdatabases where name = 'DBNAME'<br />
<br />
is more appropriate.<br />

</div>


I think

select * from sysdatabases where name = 'DBNAME'

is more appropriate.


<div>
Actually its not. &nbsp;That query only shows the data file location...it doesn't include the log file.
</div>


Actually its not.  That query only shows the data file location...it doesn't include the log file.

<div>
Just so that you know:<br />
<br />
I have chosen to do this:<br />
<br />
SELECT filename FROM MYDATABASE.dbo.sysfiles<br />
<br />
and it does what I need. thanks again.<br />

</div>


Just so that you know:

I have chosen to do this:

SELECT filename FROM MYDATABASE.dbo.sysfiles

and it does what I need. thanks again.


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
For doing a restore with move I need to be able to ask any given database what its datafile (Mdf) and its logfile (ldf) is.<br />
So I need to query the server and get these two pieces of information.<br />
How do I do that?<br />
<br />
(SQL server 2000)
</div>
</div>


Hi

For doing a restore with move I need to be able to ask any given database what its datafile (Mdf) and its logfile (ldf) is.
So I need to query the server and get these two pieces of information.
How do I do that?

(SQL server 2000)

Get path and name of data file and log file for a given sql 2000 database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.