Skip to Content
0
Former Member
Jun 09, 2015 at 04:21 PM

Finding actual disk space usages before shrinking database.

34 Views

Greetings,

I have databases with dedicated devices meaning a specific device being used by one DB only. How do I find out actual disk space being used before I decide to shrink the database. I can run dbcc allocdump in loop and then find it using a script. Is there any other method.

Thanks,

Sid.