Is there a way to set up a database table structure and indexes on a replication subscriber prior to running the snapshot agent in order to skip having to add the indexes AFTER the snapshot has been applied on the subscriber?

The reason for asking is that we have an almost unindexed database as publisher that we are going to replicate to a subscriber and have the data indexed in order to get faster lookups of the data. The database itself is around 2TB so applying the indexes takes pretty long to apply afterwards.

  • initialize from backup - have you checked that ? – Kin Shah Oct 1 at 14:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.