Wednesday, March 7, 2012

Database maintenance on replicated database

Hi,

I have transactional replication set up on a DB and run database maintenance scripts (index defrag, update stats, etc) on this DB daily.

Will the maintenance job/scripts also be propagated to the replica (subscriber) causing these maintenance operations to be performed on the replica OR do I need to create separate jobs on the replica DB (subscriber) also? I'm guessing the latter but wanted to verify to make sure I wasn't missing something. Thanks!

You need to run separate job on the replica DB. The only operations that are replicated are: DML (insert/update/delete) and certain DDL (ALTER table/proc/function).

Peng

|||Thanks Peng.

No comments:

Post a Comment