Backing Up and Restoring ZENworks Endpoint Security Management Databases


Editor's Note: This article was excerpted from this TID. Please refer to the actual TID before using this information, as Support occasionally updates the TIDs after we have highlighted them.

Backing up a ZENworks Endpoint Security Management Database

The three ZENworks Endpoint Security databases by default are named STDSDB, STMSDB, STRSDB. Here is how you back them up.

  1. Open up SQL Enterprise Manager.

  • Expand the Databases folder.

  • Right click on STDSDB and select "All Tasks", "Backup Database".

  • The SQL Server Backup dialog box is displayed. Leave the default settings as they are and click on the "Add" button

  • Select a location to save the database to and name it STDSDB.bak

  • Click OK and the database will start the backup

  • Repeat steps 3-6 for the STMSDB and the STRSDB (be sure to name the databases STMSDB.bak and STRSDB.bak respectively).

Restoring the Databases on a new ZENworks Endpoint Security Management Server

Here is how you restore/transfer databases to a new server.

  1. Install the ZENworks Endpoint Security Management Single Server install (or a multi-server install if desired).
    • If during the original install of the ZESM server product the database names were changed, be sure to use the same name during install.

  2. Also, please name the new server the same as the original server so that all existing ZESM clients will be able to communicate to this server.

  • After the installation, stop the Senforce Event Packager 3.0 and Senforce Management Service Agent 3.0 in services.

  • After the installation the new databases will be created in SQL Enterprise Manager under the Database folder. Click on the database you wish to restore, select "All Tasks" and "Restore Database".

  • The Restore database dialog box will be displayed. Select the database you wish to restore, select the "From device" radio button and do a complete restore.

  • Click the "Select Devices" button.

  • Click the Add button and browse to the .bak file of the database you did a backup on.

  • Click the OK button three times and the database will be restored.

  • Repeat steps 3-7 for the rest of the databases you need to restore.


How To-Best Practice
Comment List