script tto see all data,log,filegroup etc in box | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

script tto see all data,log,filegroup etc in box

wanted to have a script which will give me the output (all files including mdf,ldf,ndf % space used, free space available ) in all databases in the servers). example of output – dbname | mdf file | logfile | filegroup | location
db1 | mmm.mdf | mmm.ldf | primary | c:
Start with this
Select * from Master..sysfiles Madhivanan Failing to plan is Planning to fail
Hi,<br />Refer below thread which has the informatio you want :<br /><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10250′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10250′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10250>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10250</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10857′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10857′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10857>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10857</a></a><br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Madhivanan – I wanted the actual size of the all files with file group.
example in detail cr date | database |file group | field | name | filename | file size | currentsize | % used

Hi,<br />have you refered thread mentioned ?<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
Yes i did refer THE LINK … that is not showing the actual size used insted of this by using some other system sp i get the output. But as mentioned in my all threads i wanted to display the actual size used in all files including the current size…
Hi,<br />i didnt understand it correctly the script in those thread by Riya will give you detailed information about your mdf,ldf and all db’s space used ,sp_msforeachdb and sp_spaceused is also helpfull to you.<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
May check references in thishttp://vyaskn.tripod.com/track_sql_database_file_growth.htm article abotu monitoring the data file growth. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>