30.2 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 Section 32.0, Backing Up and Restoring the ZENworks Server and Certificate Authority.

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: 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 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.

  2. Stop all the ZENworks Services on the all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

  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.

  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 all the ZENworks Services on the all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.