从表中删除后数据库大小变大
从 SQL Server 数据库表中删除大量数据后，数据库大小增加.
After I delete huge amount of data from a SQL Server database table, the database size increased.
当我运行 sp_spaceused 时，它显示 2625.25 MB.在我从表中删除之前，它曾经是 ~ 1800.00 MB.
When I run sp_spaceused it shows me 2625.25 MB. It used to be ~ 1800.00 MB before I deleted from table.
有什么具体的原因，即使我删除了数据，它也会继续增长吗?
Is there any specific reason it keeps growing even if I delete data?
推荐答案
临时事务日志通常是大量删除后大小显着增加的原因.
A temporary transaction log is often the reason for a notable increase of size after a huge delete.
它最终会自行消失，但如果您需要回收空间，您可以删除这些文件.
It will eventually disappear on its own but you may remove the files if you need to reclaim the space.
相关文章