从数据库删除数据后如何减小数据库的大小? [英] How to decrease the size of the database after deleting data from database?

问题描述

我已经使用删除查询从SQL表中删除了数据.数据已成功删除，但是增加了.ldf和.mdf文件的大小.

I have deleted data from a SQL table using a delete query. The data has been deleted successfully, but it increased the size of the .ldf and .mdf files.

How to decrease the size of the database after deleting data from database?

推荐答案

你好，

使用收缩命令来执行此操作.

Hello,

Use shrink command to do so.

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