原本表大小:
删除一部分表信息后:
收缩数据文件空间:
DBCC SHRINKFILE (N'sysopertest' , 52500)
可以收缩数据文件,需要消耗事务日志空间。
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509801961l5B7.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509802049VR2t.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509802062QQuJ.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509802685JFsa.png?x-oss-process=style/bb)
删除一部分表信息后:
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_15098033383O3c.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509803375VZbx.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509803483vj4Q.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_15098035228Az2.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509803602ZdWs.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509803709ddPm.png?x-oss-process=style/bb)
收缩数据文件空间:
DBCC SHRINKFILE (N'sysopertest' , 52500)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509805184DNq7.png?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201711/4/22996654_1509805215qQMr.png?x-oss-process=style/bb)
可以收缩数据文件,需要消耗事务日志空间。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22996654/viewspace-2146829/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22996654/viewspace-2146829/