We are using Merge Replication with SQL 2005. It seems I need to change the Autogrowth settings on the Publisher but I am wondering what the impact is to Replication.
Will it force an Initialization? Anything else that I need to be aware of?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
|
Changes to the storage layer of a database, that is also a Publisher in a replication topology are not replicated to Subscribers. The only thing that can be replicated are those objects defined as Articles. For example, you can change the autogrowth setting of a given database data file at the Publisher without concern for the Subscribers. You can think of the database storage layer as an abstraction. It has to be because you may be using different storage sub system at the Publisher and Subscriber, requiring different data file placement etc. This particular type of change can be applied without the need to reinitialize replication. (For interests sake: If you were using Database Mirroring, then DDL changes of this specific nature would make it to the Mirror. Worth noting because Publishers are also often Mirrored in some environments.) |
|||||||
|
