All geek questions in one place

The MDF database file (SQL) exceeds 88 GB and I have no idea why!

For some reason, my SQL database file exploded to become over 88 GB, and I see no reason why. I run several scripts to find large tables, not counting anything superfluous. I also tried running a shrunken database (which did nothing) and file compression (which return an error).

Does anyone know what else I can do?

Thank.

+3
source share
2 answers

The first thing I would check (if you already checked the size of the table and index and still see a big difference) are the file properties.

SQL Server Management Studio , "", "".

? , ""? , SQL Server , , - , 50 , , SQL Server - .

+3

MDF ( ) LDF ( )?

, , ( ).

, ,

select *
from sys.allocation_units;

, . " " .

+1

Source: https://habr.com/ru/post/1730154/

More articles:


All Articles