Menu

Search

LOGbinder Support


How To Backup and Restore Supercharger for Disaster Recovery


Tamas Lengyel
How To

Manager

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. 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.
    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.

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