troubleshooting Question

Sharepoint 2010 sp1 upgrade Always on SQL s012

Avatar of slam68
slam68 asked on
Microsoft SQL ServerMicrosoft SharePoint
5 Comments2 Solutions598 ViewsLast Modified:
All,

Looking to move sharepoint 2010 to new app farm following sql farm move.

Moved SQL farm to new 2012 Always on group and set all db's into replication using SQL alias.

to move the app farm to new datacentre i have added teh new appservers to farm but to detach central admin and move it to new server i need to run SP configuration wizard on old server. Run this on old server and upgrade is pending.

Upgrade fails as the logging database cannot be set to simple mode as its part of a replication group.

i cannot follow usual method of stopping the mirror as the db is in Alwayson not a mirror.

the only method is below :
take the farm down
drop the logging db out of always on
point the  SQL alias  on the application and WFE at the primary node
run all the tasks to migrate to the new farm that involve the configuration wizard to ensure the logging db can go in and out of simple mode
once all tasks are complete re add the logging db into the always on farm
repoint all new farm servers at the Always on listener
bring farm back online

obviously thsi is going to have a big impact on downtime as prior to this discovery i was going to complete all reconfiguration, move of timer, crawl and central admin whilst the farm was online and the last task would be a repoint of DNS to the new WFE.

my question would be is their a method of running the configuration wizard without kicking the logging DB into simple recovery, or dropping the secondary replica but keeping the db active on the sql listener address so i dont need to repoint the sql alias.

Hoping someone can help with this,

jay
ASKER CERTIFIED SOLUTION
Ted Bouskill
Senior Software Developer
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros