Through this feature, you can back up your complete WhatsUp Gold SQL Server database to any mapped directory you have on your network. The file is saved as a .bak file and can be restored at any time. Using Backup, your data is saved to a .bak file. Restore reverses this process, overwriting your current database with the data in a .bak file.
Important: Make sure that you close the Discovery Console before running a database restore. Running the Discovery Console while running a database restore could crash the console.
Important: You can use this feature with any local instance of SQL Server whose database is named WHATSUP. This feature does not work with remote databases.
If you want to back up the SQL database to a mapped drive, you may need to change the Logon settings for the SQL Server (WHATSUP) service (or your customized SQL service). The account must have write access to the mapped drive for the backup to be successful.
To change the SQL database logon settings:
Important: This is a complete backup and restore, so any change that you make after the backup will be overwritten if a restore process is done.
To access the Database Utilities Backup and Restore features:
From the main menu in the WhatsUp Gold console, select Tools > Database Utilities > Back Up SQL Database.
- or -
Tools > Database Utilities > Restore SQL Database.