SQL Server Performance Forum – Threads Archive

Space used on specific filegroup

Hello, How can I get the space used on specific filegroup? Thanks,
Oryan

---

For this u can use DBCC showfilestats command to see the spaceused by the
file group. Rushendra

---

Via Enterprise Manager you can get all information about your filesgroups and total database, even more you can see space used and no used. Luis

---

I trust DBCC command from QA, rather getting information from GUI tools. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>