July 1, 2008 at 11:58 am
My ops team is going to move the physical storage of our SAN into a
different rack. They will be powering down my dedicated distributor,
used for brokering transactional replication w/ Push subscriptions
from one publisher.
Is there any best practice I should follow? I was told the window
would possibly be 2 hours.
The retention period is the default (all settings are actually set to
default).
The replication share is on the physical drives they are moving.
Subscribers are all in the same switch, always connected.
I was thinking about setting the services for the distributor's SQL
and Agent services to manual, power it down, do the maintenance, bring
the server back up, set the services to Auto again and start.
Do I have anything to worry about on the publisher or any other
suggestions?
Thanks 😀
Erik
July 1, 2008 at 3:06 pm
Erik (7/1/2008)
My ops team is going to move the physical storage of our SAN into adifferent rack. They will be powering down my dedicated distributor,
used for brokering transactional replication w/ Push subscriptions
from one publisher.
Is there any best practice I should follow? I was told the window
would possibly be 2 hours.
The retention period is the default (all settings are actually set to
default).
The replication share is on the physical drives they are moving.
Subscribers are all in the same switch, always connected.
I was thinking about setting the services for the distributor's SQL
and Agent services to manual, power it down, do the maintenance, bring
the server back up, set the services to Auto again and start.
Do I have anything to worry about on the publisher or any other
suggestions?
Thanks 😀
Erik
Make sure you have enough "free" log space on the publisher if transactions are going to happen during that time. Distribution agents will pickup where they left off last time.
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply