Hi
I have a corrupt PK index on a table column. It is a unique PK. It
needs to be dropped and recreated to cure the corruption.
The table is on a backup database which is in replication having
records added to it to keep the two databases in sync.
Am I correct in think that if I:
1. Suspend the replication so no data inconsistency happens on the
table while the PK is disabled.
2. Disable the corrupt PK on the table - then the index will get
dropped?
3. Enable the PK on the table - and the index will get rebuilt with
the corruption gone?
4. Re-enable the replication.
All will be fine? The table has over 9million rows so I realise it
will take a while to re-enable the primary key but as is is a backup
database in replication performance to users won't be affected.
Many thanks!