4.1 Restoring the Embedded Sybase SQL Anywhere Database on a Windows Server

  1. Stop the ZENworks Services on all 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.

  2. At the Windows server prompt, go to ZENworks_Installation_directory:\novell\zenworks\bin, and enter the following command:

    ZenworksWindowsDBRestore.bat ZENworks_Installation_directory:\Novell\Zenworks\Database c:\dbBackup\zenworks_zone_name.db c:\dbBackup\zenworks_zone_name.log

    NOTE:For the Audit database, go to ZENworks_Installation_directory:\novell\zenworks\bin, and enter the following command:

    ZenworksWindowsDBRestore.bat ZENworks_Installation_directory:\Novell\Zenworks\Database c:\dbBackup\zenworks_zone_name.db c:\dbBackup\zen_audit_zone_name.log

  3. Press any key when the following message is displayed:

    Before proceeding, ensure  that you have backed up any files in:<Installation directory>:\Novell\ZENworks\database Press any key to continue.

  4. Enter Y when the following message is displayed:

    The following services are dependent on the Novell ZENworks Datastore service. Stopping the Novell ZENworks Datastore service will also stop these services: Novell ZENworks Loader, Novell ZENworks Agent Service, Novell ZENworks Server. Do you want to continue this operation? (Y/N) [N]:

  5. Press any key when the following message is displayed:

    The Novell ZENworks Datastore service was stopped successfully. Press any key to continue.

  6. Enter Yes when the following message is displayed:

    Overwrite <installation directory>:\Novell\ZENworks\database\zenworks_<zone_name>.db? (Yes/No/All)

  7. Enter Yes when the following message is displayed:

    Overwrite <installation directory>:\Novell\ZENworks\database\zenworks_<zone_name>.log? (Yes/No/All):

    The backupFile and the backupLogFile are copied to ZENworks_Installation_directory:\Novell\ZENworks\database, and the database is restored.

  8. Run ZenworksWindowsDBRestore.bat for restoring Audit Database. ZenworksWindowsDBRestore.bat ZsENworks_Installation_directory:\Novell\Zenworks\Database c:\dbBackup\zen_audit_zone_name.db c:\dbBackup\zen_audit_zone_name.log

  9. Press any key when the following message is displayed: Before proceeding, ensure that you have backed up any files in:<Installation directory>:\Novell\ZENworks\database Press any key to continue.

  10. Press any key when the following message is displayed: The Novell ZENworks Embedded Datastore service is stopping.

    • The Novell ZENworks Embedded Datastore service is stopping.

    • The Novell ZENworks Embedded Datastore service was stopped successfully.

    • Press any key to continue.

  11. Enter Yes when the following message is displayed: Overwrite <installation directory>:\Novell\ZENworks\database\zen_audit_<zone_name>.db? (Yes/No/All)

  12. Enter Yes when the following message is displayed: Overwrite <installation directory>:\Novell\ZENworks\database\zen_audit_<zone_name>.log? (Yes/No/All)

    The backupFile and the backupLogFile are copied to ZENworks_Installation_directory:\Novell\ZENworks\database, and the database is restored.

  13. (Conditional) If you restore the database to a location other than the one mentioned in the zenworks_installation_directory\novell\zenworks\database\conf\zenworks_database.conf and zenworks_audit_database.conf files to specify the new location of the database.

  14. Start all the ZENworks Services on all 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.