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:
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
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.http://connect.microsoft.com/SQLServer/feedback/details/377223/sys-master-files-does-not-show-accurate-size-information
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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply