How to get the LDF file name of a DataBase

microsoft.public.dotnet.framework.adonet

1 Jul 2006 6:42 AM

I am using SQL2005.
How to get the LDF file name of a specified Database?

1 Jul 2006 7:07 AM

Teemu Keiski

For example looking for data about 'pubs' database

sp_helpdb 'pubs'

sp_helpdb is a built-in procedure in SQL Server.

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke

Show quote

"ad" <fly***@wfes.tcc.edu.tw> wrote in message
news:OZ2pWmNnGHA.2384@TK2MSFTNGP02.phx.gbl...
>I am using SQL2005.
> How to get the LDF file name of a specified Database?
>
>