December 31, 2011 at 6:54 pm
Sql 2008, EE, 64-bit
Error 20025:
The publication name must be unique. The specified publication name '%s' has already been used.
Suddenly appeared about 3 hours ago. No ones attempted to create a new publication...
What could this be?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 31, 2011 at 8:22 pm
Checkdb returned:
DBCC results for 'Auth_Primary'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
Keys out of order on page (1:40343481), slots 47 and 48.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:40360090) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360091).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:40360090) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360091).
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The low key value on page (1:40360091) (level 0) is not >= the key value
in the parent (1:40343481) slot 47.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The previous link (1:61344667) on page (1:40360092) does not match the
previous page (1:58423445) that the parent (1:58951485), slot 104
expects for this page.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
B-tree chain linkage mismatch. (1:58423445)->next = (1:40360092), but
(1:40360092)->Prev = (1:61344667).
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The low key value on page (1:40360093) (level 0) is not >= the key value
in the parent (1:40343481) slot 50.
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:40360093) (level 0) is not less than the
low key value in the parent (1:57022110), slot 98 of the next page
(1:58108199).
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
Page (1:40360094) is missing a reference from previous page
(1:40360093). Possible chain linkage problem.
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:40360095) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360096).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:40360095) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360096).
Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The low key value on page (1:40360096) (level 0) is not >= the key value
in the parent (1:40343481) slot 53.
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The previous link (1:58661002) on page (1:40360097) does not match the
previous page (1:40360096) that the parent (1:40343481), slot 54 expects
for this page.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
Page (1:40360097) is missing a reference from previous page
(1:58661002). Possible chain linkage problem.
Msg 8936, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
B-tree chain linkage mismatch. (1:40360093)->next = (1:58108199), but
(1:58108199)->Prev = (1:40363792).
Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:58611020) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360093).
Msg 8934, Level 16, State 3, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The high key value on page (1:58611020) (level 0) is not less than the
low key value in the parent (0:1), slot 0 of the next page (1:40360093).
Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
The previous link (1:40360091) on page (1:58611020) does not match the
previous page (1:61344667) that the parent (1:40343481), slot 49 expects
for this page.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
Page (1:58611020) is missing a reference from previous page
(1:40360091). Possible chain linkage problem.
There are 23589773 rows in 4821416 pages for object "Auth_Primary".
CHECKDB found 0 allocation errors and 19 consistency errors in table
'Auth_Primary' (object ID 1888777836
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 1, 2012 at 11:57 pm
MyDoggieJessie (12/31/2011)
Checkdb returned:DBCC results for 'Auth_Primary'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 1888777836, index ID 23, partition ID
72057594511949824, alloc unit ID 72057594551074816 (type In-row data).
.....
All the checkdb errors are about index ID 23. This is a non-clustered index.
You can try to drop and recreate this index. After that run checkdb again.
January 2, 2012 at 6:58 am
Thanks suresh,this was indeed the issue!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply