• Not Answered

SQL Server Best Practices for Sitecore 8.2 update 2

My client is working on an MSSQL database backup, VM backup, and SQL server failover strategy. I have attempted searching across the Sitecore Community and have read the related sections in the Sitecore 8.2 update 2 installation guide. Are there any other Sitecore supported resources that might lend more insight into these areas?

1 Reply

  • Hi Sherie,

    Do you mean the best practice in the website Architecture or in it's Disaster Recovery(DR) Architecture? In case you need anything on website architecture then we always have 2 database clusters one to support CM and other to support CD servers. We use clusters here for the high availability.

    Now in case of DR, we don't need high availability as it will be used only in case there is a major failure in Main infrastructure and the team will try to get the main infrastructure back on track ASAP. So in DR architecture we mostly have one DB server where the data is cloned or pushed through both the clusters in the Main architecture.

    Note: When in DR state, we ask Content Editors to freeze the content as we never clone or push the data vice versa (DR to Main).

    Please let me know if this was helpful.