Viewing 2 posts - 1 through 2 (of 2 total)
I install sql server 2005 sp3 and run command DBCC SHRINKFILE <datafile>
please refer the following links for more information
http://www.sqlserverdba.co.cc/2009/05/move-contents-between-files-within.html
http://technet.microsoft.com/en-us/library/ms189493.aspx
http://support.microsoft.com/kb/907511
September 14, 2010 at 11:12 pm
#1221123
Are you using updated SQLServer SP3? I think it has some bug fixes for deallocate of ntext,image columns when shrink data files.
Three months back, I had similar issues, I tried...
September 14, 2010 at 10:26 pm
#1221113