Unallocated space on SQL Server Database


  • Hi,

    I have a SQL Database instance in SQL Server 2008 Enterprise wich is used by Microsoft Dynamics, this database has a mirroring configuration. The last week the space start to grow a lot, so I was reviewing the disk usage report and I notice than the used space is 150GB and the Unallocated is 450GB.

    I tried to shrink database and files but the unallocated space doesn't reduce, after that I rebuilded the index and the fragmentation continues equal. 

    I'm don´t know what more can I do, someone could help me?

    Wednesday, May 16, 2018 2:45 PM

All replies