LOGbinder Support

How To Backup and Restore Supercharger for Disaster Recovery

Tamas Lengyel
How To


How To Backup the Manager

  1. Backup the master database
  2. Backup the Supercharger database

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
  5. Start the SQL Server without single-user mode
  6. Restore the Supercharger database that was backed up
  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  ????????????????

    DROP LOGIN 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 


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

On a scale of 1-5, please rate the helpfulness of this article

Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!

Still have questions - Submit a new ticket