Post reply

"REPLICATION REBUILD INDEX, REORGANIZE INDEX AND UPDATE STATISTCS IN REPLICATION TRANSACTIONAL."

  • September 24, 2009 at 1:38 am

    #214700

    Hi,

    I have a transactional replication. I rebuild index and/or reorganize index and update statistics.

    Can I replicate this updates??.

    Thanks.

  • September 24, 2009 at 2:08 am

    #1057895

    No you can't replicate these.

    The databases involved in transactional replication don't have to have exactly the same schema, so an index on the publisher may not exist on the subscriber.

    It's also possible to filter the rows that you replicate, so the index statistics on the publisher could be completely invalid on the subscriber.

  • September 24, 2009 at 2:12 am

    #1057899

    OK,

    Thank you, very much.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply