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.