question

RogueLeader avatar image
RogueLeader asked

Autogrowth and Merge Replication

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?
sql-server-2005replicationmerge-replication
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Cyborg avatar image
Cyborg answered
About autogrowth, Its explained well [here][1], Also check for [Instant File Initialization][2] by Paul Randal *"Will it force an Initialization? Anything else that I need to be aware of?"* Autogrowth has nothing to with publisher, no reinitialization of publication [1]: http://support.microsoft.com/kb/315512 [2]: http://sqlskills.com/BLOGS/KIMBERLY/post/Instant-Initialization-What-Why-and-How.aspx
10 |1200 characters needed characters left characters exceeded

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

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.