Sharepoint 2010 sp1 upgrade Always on SQL s012

Posted on 2013-12-12
Last Modified: 2013-12-14

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,

Question by:slam68
  • 3
  • 2
LVL 51

Assisted Solution

by:Ted Bouskill
Ted Bouskill earned 500 total points
ID: 39717395
OK, did you realize you can't move a SharePoint 2010 farm?  It's not supported and just doesn't work.  Too much of the configuration is tied to the systems hosting the farm because not all the settings are stored in the databases.  Even if you installed the farm originally using fully qualified domain name instead of server names it's not supported.  Some people have pulled it off by upgrading hardware in a virtual LAN with servers that have the exact same names, copying the machine images, then shutting down the old farm, however, not everyone has enough resources and skill to do it.

The safest thing you can do is setup the new farm, systematically duplicate the configuration, then move the content databases over for the non-administration web applications.  There are articles online for moving content databases that walk you through it.

I guarantee the strategy you are using will lead to error after error and there will issues that might not become apparent for weeks until the right combination of events occur to expose them.

Author Comment

ID: 39717427
Hi Ted,

The process is fine and something I've followed multiple times in the past however never transferring the db's to an alwayson 2012 multi subnet failover. The process of moving to a new db farm is easily achieved using SQL alias and moving to new app wfe is again fairly easy using scale out process, transferring services, migrating wfe and re pointing DNS.

I have now resolved this using power shell to create a temporary logging db in the physical primary node, re pointing logging at this db and running the upgrade and transfer processes. Once these had completed and all migration tasks were complete I then transferred back to the original alwayson replicated db.
It's been a fun 24 hours but got there in the end!
LVL 51

Expert Comment

by:Ted Bouskill
ID: 39717445
I guarantee that if Microsoft found out you did this and tried to get support for the farm you wouldn't get any support without paying for it.  I wouldn't do it for my farm.

Author Comment

ID: 39717505
I work for a Microsoft finalist database partner and it's not a new process  or methodology on migration just not standard so not sure where the foundation fir your guarentee stems from but no problem thanks  for the input
LVL 51

Accepted Solution

Ted Bouskill earned 500 total points
ID: 39718360
My experience is with the SharePoint Development Team as a strategic partner.

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Calculated columns 13 60
How to use odbc in vb to connect to ms sql 14 31
TSQL previous 5 22
SQL bit field not working as expected 3 0
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now