Is it possible to rebuild Index "ucMSrepl_commands" from Table : "MSrepl_commands"

• Sharon Kumar

  Ten Centuries

  Points: 1193

  More actions

  August 5, 2013 at 6:48 am

  #278318

  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,

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  August 5, 2013 at 12:04 pm

  #1638690

  May help, may not help, that depends on the error. Post the exact error message