HomeSupercharger KBHow ToHow To Backup and Restore Supercharger for Disaster Recovery

5.10. How To Backup and Restore Supercharger for Disaster Recovery

Manager 

How To Backup the Manager

(If using the SQL Server installed by Supercharger, you can use any account in the BUILTIN\Administrators group, as that group is added to the sysadmin role for the SQL Server installation.)

  1. Backup the master database (see Back Up and Restore of System Databases)
  2. Backup the Supercharger database (see Back Up and Restore of SQL Server Databases)

How To Restore the Manager

  1. Install Supercharger manager on the new server
  2. Stop the Supercharger service
  3. Restart the SQL Server in single-user mode
  4. Restore the master database that was backed up (see Back Up and Restore of System Databases)
  5. Start the SQL Server without single-user mode
  6. Restore the Supercharger database that was backed up (see Back Up and Restore of SQL Server Databases)
  7. Run the following SQL commands to reset the user account for Supercharger. (You can put the commands in a text file and run from admin command prompt: sqlcmd -H localhost -i TextFileName)
    Specify a secure password in place of  ????????????????

    USE MASTER;
    DROP LOGIN ScManagerDbUser;
    CREATE LOGIN ScManagerDbUser WITH PASSWORD=N'????????????????', CHECK_EXPIRATION=OFF;
    GRANT CONNECT ANY DATABASE TO ScManagerDbUser;
    ALTER SERVER ROLE [sysadmin] ADD MEMBER ScManagerDbUser

  8. ‚ÄčOpen Supercharger in your browser. It will complain about bad credentials. Click on the Configure button.
    1. Provide the name of the SQL Server including instance if applicable. If using default instance, just put localhost.
    2. Specify the user name (ScManagerDbUser) and password from above
    3. Click Continue
  9. Reconnect collectors
    • ‚ÄčIf the new manager has same DNS name as old manager, then collectors should just reconnect automatically
    • If the new manager has a different DNS then before, then the Server name of the manager needs to be changed in registry for each collector under the following key
      • HKEY_LOCAL_MACHINE\SOFTWARE\MTG\Supercharger\Controller\Db 

Collectors

How To Backup a Collector

Collectors do not need to be backed up.

How To Restore a Collector

  1. Install the Supercharger agent
  2. Re-register with Supercharger manager

Frequently Asked Questions

What data is lost when you restore a Manager?

When you restore the Supercharger SQL database, you will lose any changes to Supercharger objects (as opposed to WEC objects) since last backup. This includes policies, managed filters, security permissions, overrides, performance statistics, etc. This does not include Windows objects on collectors such as Subscriptions and Event Logs. This is because Supercharger always updates these objects in Supercharger to reflect Windows current state of each collector.

Can I use the above steps to migrate the Manager to another server?

Absolutely. Just make sure to rename the new server to the DNS of the original server sometime before restoring the Supercharger database (that is, before step 6 above).

Additional Useful References:

  1. Back Up and Restore of SQL Server Databases
  2. Back Up and Restore of System Databases

This page was: Helpful | Not Helpful