Forum Discussion
Ted1234
Mar 23, 2022Brass Contributor
Sharepoint disaster recovery test failure - SQL issue
My company recently tested our sharepoint disaster recovery plan, and well, let's just say it was a disaster. We have two sites, and each as two WFE's and 2 app servers. There is a sql box at ea...
SteveKnutson
Mar 27, 2022MVP
The first really big question is, was SharePoint setup using a SQL Alias or is it using the SQL servers actual name?
To support DR scenarios there are many things to consider, but most start the the initial configuration of SharePoint. The failover process should include a DNS change to tell the SharePoint servers how to find the SQL Server when failover occurs.
To support DR scenarios there are many things to consider, but most start the the initial configuration of SharePoint. The failover process should include a DNS change to tell the SharePoint servers how to find the SQL Server when failover occurs.