High Availability and Disaster Recovery of SCSM Components RRS feed

  • Question

  • We need to implement SCSM in our environment.  We are looking to utilize two-2 node SQL Cluster as the database.  We have requirements for Highly Available and Disaster Recovery Tolerant solution and have following questions:

    1.  Is it possible to have HA and DR of SCSM Server Components?
    2.  If so, how many minimum servers would be required for HA Setup?
    3.  If so, how many minimum servers would be required for DR Setup?
    4.  If so, what would be recommendation with respect to Instances? Separate instance or Shared would also work?
    5.  What would be bare minimum hardware recommendations for a small to medium size organization? any sizing help would be great help!
    6.  If possible then what should be considered while implementing this solution?
    7.  Is HA and DR really necessary for such systems?  Is it a norm in the industry?
    8.  If we do not go for HA and/or DR, how much recovery time is needed in case of a single server?
    9.  Any link to article/blog/website would be appreciated?
    Tuesday, June 18, 2019 10:10 AM


  • You can set up Highly Available/Always On Availability Groups within SQL Server.  Once you have set it up, you can go back into the DB's and point to your new SQL Listeners (this takes some small effort but it's possible).  Unfortunately, you can't set the HA/AG up first and then install, you must specify a specific SERVER/INSTANCE during installation.  I would work with your SQL DBA (if possible) to set this up.

    HA is great for allowing maintenance to be done on SQL Servers one at a time.

    Disaster Recovery, in my experience has been Backup DB's, Backup Keys, and Custom MP backups.  Normally if there is a business wide catastrophic failure, it's okay if SCSM is down for a little while you do a restore. ;)  The challenge is that there is only one SCSM Primary Management Server and only one SCSM Data Warehouse server.  With all the transactions taking place between the two, a cold-standby wouldn't work.  The VM's or Servers would have to be mirrored constantly.  But rebuilding (near the SQL Server infrastructure) could be done in relatively short order and DB's restored using the DR documentation.

    Tuesday, July 16, 2019 7:09 PM