Using the database backup and restore backup utility

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.

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:

1. Click Start > Control Panel > Administrative Tools > Services, then double click SQL Server (WHATSUP). The SQL Service Properties dialog appears.
2. Click the Log On tab on the Properties dialog.
3. Change the account logon settings as required.

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.