<div>
sp_HelpDB 'dBName' &nbsp;or <br />
sp_HelpFile 'dbNAME'
</div>


sp_HelpDB 'dBName'  or
sp_HelpFile 'dbNAME'

<div>
Is there anyway of getting just the path (without the filename) or do I have to get a substring of the physical_name?
</div>


Is there anyway of getting just the path (without the filename) or do I have to get a substring of the physical_name?

<div>
you need to use substring for this 
</div>


<div>
use adventureworks<br />
go<br />
select substring(physical_name,1,<wbr />charindex(<wbr />[name],phy<wbr />sical_name<wbr />)-1)<br />
from sys.database_files<br />

</div>


use adventureworks
go
select substring(physical_name,1,charindex([name],physical_name)-1)
from sys.database_files


<div>
if you need it without the last backslash [\], change -1 to -2 <br />
:-)
</div>


if you need it without the last backslash [\], change -1 to -2
:-)

<div>
<div class="content wysiwyg-content">
Is there a way from an SQL Server 2005 query to find out the path of the Database Files (mdf and ldf files).<br />
<br />
I can get this information from right clicking on the database, going to properties and then to Files but I need to get this information using a query to use as part of a backup query.<br />
<br />
Any ideas
</div>
</div>


Is there a way from an SQL Server 2005 query to find out the path of the Database Files (mdf and ldf files).

I can get this information from right clicking on the database, going to properties and then to Files but I need to get this information using a query to use as part of a backup query.

Any ideas

SQL Server 2005 Database File Path (mdf ldf files)

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.