从表中删除后数据库大小变大 [英] Database size bigger after delete from table

问题描述

从 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.

这篇关于从表中删除后数据库大小变大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！