database log file path and database data file path

Question

Post reply

database log file path and database data file path

river1

SSC-Insane

Points: 24309
More actions
April 30, 2010 at 4:12 am

#218350

Hi,
In witch table can i find the information of what is the log file and the data file path of each database?
Thabk you.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Renuka__ Hall of Fame Points: 3656 More actions · Answer 1

Hi,

select name,physical_name from sys.master_files

[font="Verdana"]Renuka__[/font]

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 2

SELECT name, physical_name AS current_file_location

FROM sys.master_files

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 3

Maybe this is the old way of doing it... I'd never heard of sys.master_files before.

Use MyDB;

GO

Select * from sysfiles;

(Yes, I know using * is bad, but it's a tiny table).

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 4

Methinks this post by broywin might be marketing spam since that tool has nothing to do with SQL Server.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.