SharePoint Synchronous Mirror Script

Scenario

• Setting up SQL Mirroring using the MS Case Study: http://technet.microsoft.com/en-us/library/cc531332.aspx

Issue

• When setting up the SQL script they left out a few details.

Resolution

• Use C:\Windows\System32\cliconfg.exe to create the aliases on each SharePoint server. SharePoint must point to the alias rather than directly to the SQL instance.
• The SQL alert should run the Failover job
• The Failover job should have the 2 steps
• Failover the remaining databases
• Run the Regini commands to reset the sql alias
• The account running the job must have add permissions or you may get an Regini cannot open file error
• The sql job can only run one cmdexec command per step, so you will need multiple steps or a batch file with all the commands
• The registry setting should change the alias pointer to the same server that the job is running on
• Don't Copy from the word doc, as this will take the incorrect - and ' characters.