How to get the LDF file name of a DataBase

  • Thread starter Thread starter ad
  • Start date Start date
For example looking for data about 'pubs' database

sp_helpdb 'pubs'

sp_helpdb is a built-in procedure in SQL Server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server 2000 Cannot Attach Database, Problem with LDF File 0
How to backup a database. 1
Multiple Copies of .ldf and .mdf Files 2
SQL Server 2005 installation 3
attach user mdf problem 3
Changing Location of BCM data files 1
Overflow from Calculation - How do I do Calculation? 10
How to make a backup from vb.net 2

Back
Top