Alwayson Maintenance secondary replica

Question

Alwayson Maintenance secondary replica

vincenzo_capelli

SSChasing Mays

Points: 606
More actions
April 6, 2016 at 5:23 am

#309653

Hi,
I have to plan Storage Area Network maitenance into the D.Recovery site.
With this activity the Sql server configured as secondary replica should be stopped.
What's the best practice for this situation? Do I have to "Suspend Data Movement" on Primary replica? (My replica is async)
Thanks
Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

If you are async my understanding is you don't need to do anything for taking the secondary offline. Do note that you may throw errors that monitoring systems will catch and most importantly all primary DML activity will queue up and that means transaction log growth.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

vincenzo_capelli SSChasing Mays Points: 606 More actions · Answer 2

On primary replica, the Log driver is well size, I think this shouldn't be a big issue.

Summarizing, into the D.R. server room I'll power off Sql Server (secondary replica), no other activity is required on primary replica.

When the Storage area network maintenance has finished, I startup the secondary replica and Always-on should start to replicate.

I understood correctly?

Thanks

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

vincenzo_capelli (4/6/2016)
On primary replica, the Log driver is well size, I think this shouldn't be a big issue.
Summarizing, into the D.R. server room I'll power off Sql Server (secondary replica), no other activity is required on primary replica.
When the Storage area network maintenance has finished, I startup the secondary replica and Always-on should start to replicate.
I understood correctly?
Thanks

1) It concerns me that you are having to manage a system responsible for your company's ability to process data (and thus survive) without really understanding the subsystems that allow for that continuance. This is a VERY common flaw I see as a consultant, and I have seen company's go out of business because they weren't doing things right or didn't know what they were doing. Not a personal attack here, just a blunt statement of fact.

2) I would do this in a controlled manner: https://msdn.microsoft.com/en-us/library/ff878303.aspx

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

vincenzo_capelli (4/6/2016)
Hi,
I have to plan Storage Area Network maitenance into the D.Recovery site.
With this activity the Sql server configured as secondary replica should be stopped.
What's the best practice for this situation? Do I have to "Suspend Data Movement" on Primary replica? (My replica is async)
Thanks
Regards

How long do you expect this secondary to be down for?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉