question

DSM avatar image
DSM asked

NEW TABLE CREATION IN REPLICATION SETUP AND REINITIALIZATION

There is a business need that a new table needs to be created at all servers and it should be part of replication. We already have replication set between head quarter server and location servers;'replicate schema changes' is also set to true. We will need to fire the creation script manually at head quarter. After say creation of this new table at head quarters; it has to be ticked for replication. Is it necessary to reinitialize at head quarter after ticking for replication; so that it is taken care in replication from head quarter to location. Is there any less processor/RAM/hard disk intensive way out to achieve it in replication (as I will need to it in serial at head quarter first and then one by one at all other location servers).

sql server 2008r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.