Take the 2-minute tour ×
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.

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?

share|improve this question
add comment

1 Answer

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.)

share|improve this answer
    
Thanks for the quick answer. We are gonna wait till this weekend when our users are out and perform a full backup first. I have no idea if that's neccesary but then I am not in charge of my department.... :) Thanks –  Refracted Paladin Apr 19 '12 at 17:42
1  
You're welcome. Yes absolutely take a FULL database backup. When making structural changes to a database, you always want to have a full database backup to hand. –  John Sansom Apr 19 '12 at 18:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.