November 10, 2011 at 8:03 pm
Comments posted to this topic are about the item Database Files Physical Location
November 11, 2011 at 12:46 am
Or perhaps simpler:
select
db_name= d.name,
filename= f.name,
file_location= f.physical_name
from sys.master_filesf
join sys.databasesd on d.database_id = f.database_id
🙂
November 11, 2011 at 9:55 am
Also want to add the clause:
Where status <> 66056 -- offline
November 11, 2011 at 11:33 am
I got a bit interested in the Size column, but then later found out it was kind of bogus.
November 12, 2011 at 12:59 am
or
where d.state_desc = 'ONLINE'
🙂
November 12, 2011 at 1:12 am
andre.quitta (11/11/2011)
I got a bit interested in the Size column, but then later found out it was kind of bogus.
Spot on, and well pointed out, but the original article was about file location, which sys.master_files does represent accurately.
May 12, 2016 at 6:34 am
Thanks for the script.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply