13.0 Restoring the External Sybase Database

IMPORTANT:If the database is located on a ZENworks Server, you must first restore the ZENworks Server, then restore the ZENworks database. Ensure that you have backed up the ZENworks Server and the database (at least once). You can also back up the ZENworks database on a regular basis. However, you can back up the server and the database in any order.

For more information about backing up and restoring the ZENworks Server, see Backing Up and Restoring the ZENworks Server and Certificate Authority in the ZENworks Disaster Recovery Reference.

You can choose to restore the backed-up external Sybase database (Remote OEM Sybase or Remote Sybase SQL Anywhere) on the same device that has database server installed or to a different device.

To restore the backed-up external Sybase database:

  1. Stop the Novell ZENworks Embedded Datastore service on the database server on which you want to restore the backed-up database. If you choose to restore the backed-up database on a different device, you must stop the service on that device as well as on the database server.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Right-click the Novell ZENworks Embedded Datastore service, then click Stop, or select the Novell ZENworks Embedded Datastore service, then click Stop icon on the toolbar.

    • On Linux: At the console prompt, enter

      • /etc/init.d/sybase-asa stop on SLES 11.

      • systemctl stop sybase-asa.service on SLES 12.

  2. Stop the ZENworks services on the ZENworks Servers in the Management Zone. For more information, see Step 2.a in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.

  3. Copy the following files from the device where the external Sybase database is backed up to the device on which you want to restore the external Sybase database:

    • zenworks_zone_name.db

    • zenworks_zone_name.log

    By default, the files must be copied to the ZENworks_Installation_directory:\Novell\Zenworks\Database on a Windows Sybase database server, and to /var/opt/novell/zenworks/database/ on a Linux Sybase database server.

  4. Start the Novell ZENworks Embedded Datastore service on the database server on which you restored the backed-up database. If you have restored the backed-up database to a different device, you must start the service on that device as well as on the database server.

    • On Windows: Do the following:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Right-click the Novell ZENworks Embedded Datastore service, then click Start, or select the Novell ZENworks Embedded Datastore service, then click Start icon on the toolbar.

    • On Linux: At the console prompt, enter

      • /etc/init.d/sybase-asa start on SLES 11.

      • systemctl start sybase-asa.service on SLES 12.

  5. (Conditional) If you restore the database to a location other than the one given in the zenworks_database.conf file, you must manually edit the file to specify the new location of the database. The zenworks_database.conf file is located by default in the zenworks_installation_directory\novell\zenworks\database\conf\ directory on Windows and in the /etc/opt/novell/zenworks/ directory on Linux.

  6. Start the ZENworks services on the ZENworks Servers in the Management Zone. For more information, see Step 2.c in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.