I am trying shrink a file which is of 1TB to 500GB. Used space is 250GB.
When I try to shrink the data file, it throws me below error.
Any idea why it is throwing that error? How to troubleshoot this issue and what are the options available if I had to shrink this data file?
Msg 511, Level 16, State 1, Line 62
Cannot create a row of size 8193 which is greater than the allowable maximum row size of 8060.
DBCC SHRINKFILE: Heap page 1:134083999 could not be moved.
The statement has been terminated.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.