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 .dat file and can be restored at any time. Using Backup, your data is saved to a .dat file. Restore reverses this process, overwriting your current database with the data in a .dat file.
Caution: You cannot use this feature to back up from, or restore to a remote database, (meaning the SQL/MSDE server is located on a remote server) or to a local database that has an instance name other than WHATSUP.
If you want to back up the SQL database to a mapped drive, you may need to change the Logon settings for the MSSQL$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:
Note: 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.