开发者

Reallocating SQL Server Image Space

开发者 https://www.devze.com 2023-02-07 01:53 出处:网络
I recently removed a few gigabytes worth of data from my server running SQL Server 2005.This data was of t开发者_高级运维he \'Image\' datatype.After deleting the records, the PC has yet to show that t

I recently removed a few gigabytes worth of data from my server running SQL Server 2005. This data was of t开发者_高级运维he 'Image' datatype. After deleting the records, the PC has yet to show that that data has been actually freed. I've tried DBCC CLEANTABLE and DBCC SHRINKFILE, and it's just not working. I've googled this for a while, and I haven't come across a definite answer. Has anyone else run into this situation before? How did you solve it?

Thanks, Aaron


See: DBCC SHRINKFILE and SHRINKDATABASE commands may not work because of sparsely populated text, ntext, or image columns

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号