Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is it possible to rebuild Index "ucMSrepl_commands" from Table : "MSrepl_commands" Expand / Collapse
Author
Message
Posted Monday, August 5, 2013 6:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 9:53 AM
Points: 52, Visits: 686
Hi All,

One of our production environment the distribution database got corrupted.
We have observed that Distribution Cleanup is keeping on failing and after running dbcc checkdb commands we found that in "MSrepl_commands" table the index "ucMSrepl_commands" is corrupted.

To resolve this we need to restore a page or repairing the database.

I would like to know that it is possible to resolve this issue by rebuilding the 'ucMSrepl_commands' Index


Thanks,

Post #1480899
Posted Monday, August 5, 2013 12:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:42 PM
Points: 224, Visits: 1,732
May help, may not help, that depends on the error. Post the exact error message
Post #1481026
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse