We got a database with a very large table, which holds a IMAGE field. There
are a lot of inconsistensies on this specific table. A dbcc checkstorage
resulted in ca. 750 hard- and 350 softfaults :
frs2_srcimage 255 100030 page format error
I thought a 'dbcc rebuild_text(frs2_srcimage)' would fix this table, but
The tranlog is filling up while the rebuild_text() is running. Dumping the
tranlog doesn't clear is. 'tricks' like dumping with no_log etc also
won't work.
This results in a situation where my rebuild_text() nevers ends and my
frs2_srcimage never get's rebuilded
Are there any suggestions on how to 'attack' this table-storage problem?