I wonder if it is possible to fix the lost index using the replication. i.e. In publisher server, we have a certain index for a table. But in the replication server, for some reason, the index was not created and I want to include the index creation DDL
to the replication.
Or I have to create the index on the replication directly. If so, is there any risk to deploy directly on the replication server? Will it cause any conflict to the replication? Cause any log file expansion? Or others, please advise.
View Complete Post