Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 how to list all Transaction logs in database

Author  Topic 

sunilsi
Starting Member

21 Posts

Posted - 2008-12-17 : 08:12:48
Friends,

Is there a way to list all transaction log names used in a database through sql command??

Regards,
Linus

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-17 : 09:29:49
Do you mean LDF file name? Look as sysfiles or sysaltfiles in Master DB.
Go to Top of Page

sunilsi
Starting Member

21 Posts

Posted - 2008-12-17 : 23:43:57
yes, the ldf file... thanks for the info....
Go to Top of Page
   

- Advertisement -