asked on

SQL Index trouble

I'm having trouble with a table and I've heard to rebuild the index. I'm getting errors while trying to do this. I think this problem is realated to changing the table name as seen below:

Any ideas?

knightEknight

It looks like there is only one index and it is the Primary Key index.

If this is so, you can try this:

Right-click on the table and choose Design. Then highlight all the columns that are part of the key (yellow key next to them). Then click on the key button -- this will remove the primary key (e.g. the index). Click save. Then highlight all of those columns again and click the key again to re-create a Primary Key index. Pay attention to the order of the columns in the index.

knightEknight

... click save again when done. :)

hrolsons

ASKER

Thank you so much for your help.

When I try to remove the PrimaryKey I get an error:

knightEknight

eh-hem. new strategy ...

Start by making a backup of the database.

First, copy all of the data in table photos to a temporary table:

select *
into photos_TEMP
from photos

Next, truncate the photos table:

truncate table photos

Next, repeat the steps from the first post to delete and re-create the PK index.
If it doesn't work, drop the photos table and rename photos_TEMP to photos, recreate the key.

If it does work, move all the data back into photos from photos_TEMP:

insert into photos
select * from photos_TEMP

(This last part will only work if there are no identity columns on the table - let me know if there are.)

hrolsons

ASKER

I failed on step 1:

Do you think I should continue?

ASKER CERTIFIED SOLUTION

knightEknight

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hrolsons

ASKER

Rebooted and when I got back in the db now says "In Recovery".

Fingers are double crossed. I do have a backup, but it's a week old.

hrolsons

ASKER

Still can't do a backup: "cyclic redundancy check"

knightEknight

ouch. there are so many things the could be wrong here. Let's start by running this:

select * from master..sysdatabases where name='Photo' -- I assume Photo is the name of the catalog

what is in the status column of the query above?

hrolsons

ASKER

hrolsons

ASKER

I don't know if it's related to the last query, but the computer just crashed and automatically restarted the machine. It listed "Blue Screen" as the reason for the crash.

Yikes. This is a brand new machine, 2 weeks old, running a 100Gb SSD drive.

knightEknight

You may have a bad drive. Hard to tell from here.

If it comes back up, try running the following SQL:

RESTORE DATABASE Photo WITH RECOVERY

If it works, make a backup, and copy the backup to a thumbdrive or otherwise get it off that disk!

knightEknight

... and make sure you have a copy of your previous backup off-disk as well.

hrolsons

ASKER

Didn't work:

hrolsons

ASKER

Yes, I do have a backup on another physical drive.

knightEknight

okay, let's try this:

DBCC CHECKDB ('Photo') WITH NO_INFOMSGS, ALL_ERRORMSGS

hrolsons

ASKER

Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1074482) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087053) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087054) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094969) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094972) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113341) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113342) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1508810542). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1509573812). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -10.
CHECKDB found 0 allocation errors and 9 consistency errors not associated with any single object.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:11962) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:11962), slot 0, text ID 336855040 is referenced by page (1:11992), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1074482) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1074482), slot 0, text ID 304218112 is referenced by page (1:1074478), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087053) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087053), slot 0, text ID 1729495040 is referenced by page (1:1087043), slot 6, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087054) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087054), slot 0, text ID 1553989632 is referenced by page (1:1087043), slot 7, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094969) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094969), slot 0, text ID 1022230528 is referenced by page (1:1095065), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094972) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094972), slot 0, text ID 992411648 is referenced by page (1:1095340), slot 1, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1095803) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data), page (1:1095803). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1095803), slot 0, text ID 834666496 is referenced by page (1:1095796), slot 6, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113341) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113341), slot 0, text ID 568131584 is referenced by page (1:1113776), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113342) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113342), slot 0, text ID 1542258688 is referenced by page (1:1113785), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1360515) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1360515), slot 0, text ID 1053229056 is referenced by page (1:1360520), slot 1, but was not seen in the scan.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:11992:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1059139:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1074478:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1077251:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1087043:6)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1087043:7)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1095065:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1095340:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1095796:6)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1113776:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1113785:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1120337:14)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1120890:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1126680:3)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1128970:5)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1131051:10)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1143399:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1155508:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1158652:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1166457:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1169792:21)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1199283:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1208818:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1210613:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1218270:24)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1252628:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1348053:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1351489:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1351854:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1360520:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1363019:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1386997:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1392718:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1394839:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1401787:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1406296:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1407332:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1408015:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1408848:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1413683:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1424904:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1429868:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1434979:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1448792:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1451350:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1453682:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1456887:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1469294:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1482455:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1483441:3)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1483697:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1493075:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1583236:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1604976:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1648581:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1650463:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1704378:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1773314:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1780926:2)
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Page (1:1803662) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803662) was not seen in the scan although its parent (1:1803766) and previous (1:1803661) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803663) is missing a reference from previous page (1:1803662). Possible chain linkage problem.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1832011:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1842596:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1843585:12)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1848513:4)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1881477:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1882059:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1883885:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1899830:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1901908:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1907930:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1914720:15)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1942178:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1942466:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1959485:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1964232:20)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:2013245:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:2032413:4)
CHECKDB found 0 allocation errors and 102 consistency errors in table 'photos' (object ID 261575970).
CHECKDB found 0 allocation errors and 111 consistency errors in database 'Photo'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Photo).

hrolsons

ASKER

BTW, Thank You SO MUCH!!!

knightEknight

Well, the news may not be good. We'll give this a try, but if it doesn't work I'm out of ideas. If it does, you will still probably face some loss of data. If so, you can restore your previous backup to a different name (e.g. Photo_Prev) and then copy what data you can from Photo to Photo_Prev, then backup Photo_Prev and restore it as Photo. But first ... cross your fingers and run:

use Photo;
go
DBCC CHECKDB
go

hrolsons

ASKER

DBCC results for 'Photo'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1074482) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087053) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087054) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094969) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094972) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113341) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113342) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1508810542). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1509573812). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -10.
CHECKDB found 0 allocation errors and 9 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
There are 662 rows in 8 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 97 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 115 rows in 2 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 131 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 68 rows in 1 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 536 rows in 10 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 8 rows in 4 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 180 rows in 2 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 331 rows in 2 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 185 rows in 23 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 146 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 129 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 7 rows in 1 pages for object "sys.syssoftobjrefs".
DBCC results for 'photo_size'.
There are 558286 rows in 4298 pages for object "photo_size".
DBCC results for 'photos'.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:11962) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:11962), slot 0, text ID 336855040 is referenced by page (1:11992), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1074482) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1074482), slot 0, text ID 304218112 is referenced by page (1:1074478), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087053) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087053), slot 0, text ID 1729495040 is referenced by page (1:1087043), slot 6, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087054) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087054), slot 0, text ID 1553989632 is referenced by page (1:1087043), slot 7, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094969) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094969), slot 0, text ID 1022230528 is referenced by page (1:1095065), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094972) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094972), slot 0, text ID 992411648 is referenced by page (1:1095340), slot 1, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1095803) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data), page (1:1095803). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1095803), slot 0, text ID 834666496 is referenced by page (1:1095796), slot 6, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113341) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113341), slot 0, text ID 568131584 is referenced by page (1:1113776), slot 1, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113342) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113342), slot 0, text ID 1542258688 is referenced by page (1:1113785), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1360515) could not be processed. See other errors for details.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1360515), slot 0, text ID 1053229056 is referenced by page (1:1360520), slot 1, but was not seen in the scan.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:11992:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1059139:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1074478:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1077251:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1087043:6)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1087043:7)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1095065:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1095340:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1095796:6)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1113776:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1113785:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1120337:14)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1120890:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1126680:3)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1128970:5)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1131051:10)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1143399:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1155508:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1158652:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1166457:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1169792:21)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1199283:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1208818:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1210613:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1218270:24)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1252628:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1348053:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1351489:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1351854:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1360520:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1363019:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1386997:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1392718:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1394839:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1401787:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1406296:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1407332:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1408015:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1408848:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1413683:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1424904:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1429868:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1434979:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1448792:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1451350:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1453682:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1456887:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1469294:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1482455:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1483441:3)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1483697:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1493075:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1583236:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1604976:8)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1648581:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1650463:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1704378:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1773314:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1780926:2)
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Page (1:1803662) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803662) was not seen in the scan although its parent (1:1803766) and previous (1:1803661) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803663) is missing a reference from previous page (1:1803662). Possible chain linkage problem.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1832011:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1842596:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1843585:12)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1848513:4)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1881477:2)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1882059:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1883885:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1899830:0)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1901908:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1907930:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1914720:15)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1942178:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1942466:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1959485:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1964232:20)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:2013245:1)
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:2032413:4)
There are 946404 rows in 746364 pages for object "photos".
CHECKDB found 0 allocation errors and 102 consistency errors in table 'photos' (object ID 261575970).
DBCC results for 'assignment'.
There are 132486 rows in 1275 pages for object "assignment".
DBCC results for 'photos_TEMP'.
There are 0 rows in 0 pages for object "photos_TEMP".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'master_photo_size_unique'.
There are 453243 rows in 3040 pages for object "master_photo_size_unique".
DBCC results for 'photo_detail'.
There are 135271 rows in 20995 pages for object "photo_detail".
CHECKDB found 0 allocation errors and 111 consistency errors in database 'Photo'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Photo).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

knightEknight

okay, now to attempt the repair:

use master
GO
ALTER DATABASE Photo SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
go
use Photo
GO
DBCC CHECKDB ('Photo', REPAIR_ALLOW_DATA_LOSS);
go
ALTER DATABASE Photo SET MULTI_USER;
go

knightEknight

oops, remove the use Photo line - it is not needed.

hrolsons

ASKER

I ran it as posted and got:

Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
DBCC results for 'Photo'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1074482) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087053) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1087054) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094969) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1094972) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113341) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:1113342) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1508810542). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
Could not repair this error.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4524624933614125056 (type Unknown), page (11101:1509573812). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -10.
Could not repair this error.
CHECKDB found 0 allocation errors and 9 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
There are 662 rows in 8 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 97 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 115 rows in 2 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 131 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 68 rows in 1 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 536 rows in 10 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 8 rows in 4 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 180 rows in 2 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 331 rows in 2 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 185 rows in 23 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 146 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 129 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 7 rows in 1 pages for object "sys.syssoftobjrefs".
DBCC results for 'photo_size'.
There are 558286 rows in 4298 pages for object "photo_size".
DBCC results for 'photos'.
Repair: The Clustered index successfully rebuilt for the object "dbo.photos" in database "Photo".
Repair: The page (1:11962) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1074482) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1087053) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1087054) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1094969) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1094972) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1095803) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1113341) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1113342) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: The page (1:1360515) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data).
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:11992), slot 1. Indexes will be rebuilt.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1059139), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1059139), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1074478), slot 1. Indexes will be rebuilt.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1077251), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1729495040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1077251), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1087043), slot 6. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1729495040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1087043), slot 6.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1087043), slot 7. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1087043), slot 7.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1095065), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1095065), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1095340), slot 1. Indexes will be rebuilt.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1095796), slot 6. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 834666496, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1095796), slot 6.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1113776), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1113776), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1113785), slot 0. Indexes will be rebuilt.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1120337), slot 14. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1120337), slot 14.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1120890), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 834666496, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1120890), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1126680), slot 3. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1126680), slot 3.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1128970), slot 5. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1128970), slot 5.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1131051), slot 10. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1131051), slot 10.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1143399), slot 8. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1143399), slot 8.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1155508), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1155508), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1158652), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1158652), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1166457), slot 8. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1166457), slot 8.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1169792), slot 21. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1169792), slot 21.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1199283), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1199283), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1208818), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1208818), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1210613), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1210613), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1218270), slot 24. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1218270), slot 24.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1252628), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1252628), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1348053), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 834666496, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1348053), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1351489), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1351489), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1351854), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1351854), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1360520), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1360520), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1363019), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1363019), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1386997), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1386997), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1392718), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1392718), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1394839), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1394839), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1401787), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1401787), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1406296), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1406296), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1407332), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1407332), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1408015), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1408015), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1408848), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1408848), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1413683), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1413683), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1424904), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 834666496, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1424904), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1429868), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1429868), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1434979), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1434979), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1448792), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1448792), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1451350), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1451350), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1453682), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1453682), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1456887), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1456887), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1469294), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1469294), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1482455), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1482455), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1483441), slot 3. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1483441), slot 3.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1483697), slot 8. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1483697), slot 8.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1493075), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1493075), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1583236), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1583236), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1604976), slot 8. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1604976), slot 8.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1648581), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1648581), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1650463), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1650463), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1704378), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 304218112, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1704378), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1773314), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 304218112, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1773314), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1780926), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1780926), slot 2.
Repair: The page (1:1803662) has been deallocated from object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data).
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1832011), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1542258688, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1832011), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1842596), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1842596), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1843585), slot 12. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1843585), slot 12.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1848513), slot 4. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1053229056, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1848513), slot 4.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1881477), slot 2. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1881477), slot 2.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1882059), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1882059), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1883885), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1553989632, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1883885), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1899830), slot 0. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1729495040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1899830), slot 0.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1901908), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1901908), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1907930), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 992411648, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1907930), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1914720), slot 15. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 568131584, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1914720), slot 15.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1942178), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 304218112, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1942178), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1942466), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1729495040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1942466), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1959485), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 336855040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1959485), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:1964232), slot 20. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1729495040, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:1964232), slot 20.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:2013245), slot 1. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 834666496, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:2013245), slot 1.
Repair: Deleted record for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), on page (1:2032413), slot 4. Indexes will be rebuilt.
Repair: Deleted off-row data column with ID 1022230528, for object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data) on page (1:2032413), slot 4.
Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1 will be rebuilt.
The error has been repaired.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:11962) could not be processed. See other errors for details.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:11962), slot 0, text ID 336855040 is referenced by page (1:11992), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1074482) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1074482), slot 0, text ID 304218112 is referenced by page (1:1074478), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087053) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087053), slot 0, text ID 1729495040 is referenced by page (1:1087043), slot 6, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1087054) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1087054), slot 0, text ID 1553989632 is referenced by page (1:1087043), slot 7, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094969) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094969), slot 0, text ID 1022230528 is referenced by page (1:1095065), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1094972) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1094972), slot 0, text ID 992411648 is referenced by page (1:1095340), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1095803) could not be processed. See other errors for details.
The error has been repaired.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data), page (1:1095803). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1095803), slot 0, text ID 834666496 is referenced by page (1:1095796), slot 6, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113341) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113341), slot 0, text ID 568131584 is referenced by page (1:1113776), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:1113342) allocated to object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1113342), slot 0, text ID 1542258688 is referenced by page (1:1113785), slot 0, but was not seen in the scan.
The error has been repaired.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data): Page (1:1360515) could not be processed. See other errors for details.
The error has been repaired.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042122240 (type LOB data). The off-row data node at page (1:1360515), slot 0, text ID 1053229056 is referenced by page (1:1360520), slot 1, but was not seen in the scan.
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:11992:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1059139:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1074478:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1077251:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1087043:6)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1087043:7)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1095065:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1095340:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1095796:6)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1113776:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1113785:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1120337:14)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1120890:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1126680:3)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1128970:5)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1131051:10)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1143399:8)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1155508:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1158652:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1166457:8)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1169792:21)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1199283:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1208818:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1210613:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1218270:24)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1252628:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1348053:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1351489:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1351854:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1360520:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1363019:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1386997:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1392718:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1394839:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1401787:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1406296:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1407332:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1408015:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1408848:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1413683:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:1424904:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1429868:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1434979:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1448792:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1451350:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1453682:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1456887:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1469294:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1482455:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1483441:3)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1483697:8)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1493075:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1583236:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1604976:8)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1648581:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1650463:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1704378:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1773314:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1780926:2)
The error has been repaired.
Msg 8928, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Page (1:1803662) could not be processed. See other errors for details.
The error has been repaired.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
The error has been repaired.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data), page (1:1803662). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12584969 and -4.
The error has been repaired.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803662) was not seen in the scan although its parent (1:1803766) and previous (1:1803661) refer to it. Check any previous errors.
The error has been repaired.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data). Page (1:1803663) is missing a reference from previous page (1:1803662). Possible chain linkage problem.
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1542258688 owned by data record identified by RID = (1:1832011:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1842596:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:1843585:12)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1053229056 owned by data record identified by RID = (1:1848513:4)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1881477:2)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1882059:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1553989632 owned by data record identified by RID = (1:1883885:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1899830:0)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1901908:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 992411648 owned by data record identified by RID = (1:1907930:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 568131584 owned by data record identified by RID = (1:1914720:15)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 304218112 owned by data record identified by RID = (1:1942178:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1942466:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 336855040 owned by data record identified by RID = (1:1959485:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1729495040 owned by data record identified by RID = (1:1964232:20)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 834666496 owned by data record identified by RID = (1:2013245:1)
The error has been repaired.
Msg 8929, Level 16, State 1, Line 1
Object ID 261575970, index ID 1, partition ID 72057594040025088, alloc unit ID 72057594042187776 (type In-row data): Errors found in off-row data with ID 1022230528 owned by data record identified by RID = (1:2032413:4)
The error has been repaired.
There are 946404 rows in 746364 pages for object "photos".
CHECKDB found 0 allocation errors and 102 consistency errors in table 'photos' (object ID 261575970).
CHECKDB fixed 0 allocation errors and 102 consistency errors in table 'photos' (object ID 261575970).
DBCC results for 'assignment'.
There are 132486 rows in 1275 pages for object "assignment".
DBCC results for 'photos_TEMP'.
There are 0 rows in 0 pages for object "photos_TEMP".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'master_photo_size_unique'.
There are 453243 rows in 3040 pages for object "master_photo_size_unique".
DBCC results for 'photo_detail'.
There are 135271 rows in 20995 pages for object "photo_detail".
CHECKDB found 0 allocation errors and 111 consistency errors in database 'Photo'.
CHECKDB fixed 0 allocation errors and 102 consistency errors in database 'Photo'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Photo, repair_allow_data_loss).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

hrolsons

ASKER

I need to grab my kiddo from school and will be back on in 45min.

knightEknight

As you can see from the first messages it rolled back some data, but if it worked right, you should be able to get to the data now -- unless it is still in "Recovery" mode?

Scott Pletcher

For future reference, the FIRST thing to do when you notice a problem with a database is to **check the SQL error log**. It can give you detailed info on the problem ... unless SQL has been restarted so many times since then that the log with the details has scrolled off and been deleted.

Also, if you find the error details in an error log, copy that error log to a new file name.

hrolsons

ASKER

Hard Disk Failure