Nilssond
Hall of Fame
Points: 3285
More actions
February 10, 2004 at 1:22 pm
#83818
After creating several indexes on several tables on a different filegroup from the table data, I ran DBCC CHECKDB and got an 806 error. What are my options after DBCC CHECKDB('<databasename>', REPAIR_WITH_DATA_LOSS)
errored out again?
Allen Cui-55137
SSC Guru
Points: 51650
February 10, 2004 at 1:47 pm
#493486
CheckDB will tell your which tablea and indexs in trouble. Try to drop the indexes, run dbcc checktable and recreate the indexes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply