Solved

SQL Index trouble

Posted on 2012-03-13
27
383 Views
Last Modified: 2012-03-22
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:
Screen Capture
Any ideas?
0
Comment
Question by:hrolsons
  • 14
  • 12
27 Comments
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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.
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
... click save again when done.  :)
0
 

Author Comment

by:hrolsons
Comment Utility
Thank you so much for your help.

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

Screen Error
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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.)
0
 

Author Comment

by:hrolsons
Comment Utility
I failed on step 1:

Screen Error
Do you think I should continue?
0
 
LVL 33

Accepted Solution

by:
knightEknight earned 500 total points
Comment Utility
It's hard to make a recommendation here - it looks like you may have disk errors or some kind of corruption in the database.

I suggest you start by either re-starting the SQL Service, or rebooting the machine, and then try the backup again.
0
 

Author Comment

by:hrolsons
Comment Utility
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.
0
 

Author Comment

by:hrolsons
Comment Utility
Still can't do a backup:  "cyclic redundancy check"
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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?
0
 

Author Comment

by:hrolsons
Comment Utility
Status
0
 

Author Comment

by:hrolsons
Comment Utility
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.
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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!
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
... and make sure you have a copy of your previous backup off-disk as well.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:hrolsons
Comment Utility
Didn't work:

Error
0
 

Author Comment

by:hrolsons
Comment Utility
Yes, I do have a backup on another physical drive.
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
okay, let's try this:

  DBCC CHECKDB ('Photo') WITH NO_INFOMSGS, ALL_ERRORMSGS
0
 

Author Comment

by:hrolsons
Comment Utility
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).
0
 

Author Comment

by:hrolsons
Comment Utility
BTW, Thank You SO MUCH!!!
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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
0
 

Author Comment

by:hrolsons
Comment Utility
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.
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
oops, remove the  use Photo  line - it is not needed.
0
 

Author Comment

by:hrolsons
Comment Utility
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.
0
 

Author Comment

by:hrolsons
Comment Utility
I need to grab my kiddo from school and will be back on in 45min.
0
 
LVL 33

Expert Comment

by:knightEknight
Comment Utility
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?
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
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.
0
 

Author Closing Comment

by:hrolsons
Comment Utility
Hard Disk Failure
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sql query 7 34
SQL Select Prior Ship Date Data 2 28
SQL JOIN 6 31
sql query to reportserver  table error 3 20
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now