Reallocating SQL Server Image Space
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
精彩评论