question

Wolfkat avatar image
Wolfkat asked

P2V SQL 2008 Distribtor

Hi all, We have a scaled out replication environment and we need to virtualize the Distributor server. Basically our thought is to let the publisher server continue to service the application while we shut the distributor down and VM the server. Everything will remain the same from server name on down and the outage will run for 4 hours while we VM the current distributor. Our thought is the log readers will go into re-try until we bring the new distributor back online. Does anyone see an issue with this approach?
replication
10 |1200

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

1 Answer

·
SirSQL avatar image
SirSQL answered
Your biggest concern will be transaction log growth during that period. As the log reader will not be able to deliver transactions to the distributor they will not be cleared from the log and growth will occur. Ensure that you have sufficient disk capacity to allow for that and you should be ok.
10 |1200

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.