How To Backup the Manager
- Backup the master database
- Backup the Supercharger database
How To Restore the Manager
- Install Supercharger manager on the new server
- Stop the Supercharger service
- Restart the SQL Server in single-user mode
- Restore the master database that was backed up
- Start the SQL Server without single-user mode
- Restore the Supercharger database that was backed up
- Run the following SQL commands to reset the user account for Supercharger. Specify a secure password in place of ????????????????
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
- Open Supercharger in your browser. It will complain about bad credentials.
- Provide the name of the SQL Server including instance if applicable. If using default instance, just put localhost.
- Specify the user name (ScManagerDbUser) and password from above
- Click Continue
- 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
How To Backup a Collector
Collectors do not need to be backed up.
How To Restore a Collector
- Install the Supercharger agent
- 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:
- Back Up and Restore of SQL Server Databases
- Back Up and Restore of System Databases
Optionally provide private feedback to help us improve this article...
Thank you for your feedback!