Database Maintenance Plan and Replication
Posted on 2004-03-31
I am having trouble finding out what way Replication affects a Database Maintenance Plan.
I have SQL SERVER 2000 publisher to a few MSDE pull subscriptions (merge replication). I would like to scehdule optimization and integrity checks, but I am not sure how replication will affect this task. How will the db checks affect my replicated environment? With replication in place, does this mean I must schedule a similar plan for each replica?
Thanks in advance