Before configuring the server to point the new MS SQL database, do the following:
Make sure that the ZENworks Server is configured to an MS SQL database. The database can be installed on the ZENworks Server or on a different device. Assume that the device that currently host the MS SQL database is called MSDB1.
Make sure that you have another Windows device with an MS SQL database installed. Assume that this device is called MSDB2. For more information on how to install an MS SQL database, see Installing an External ZENworks Database
in the ZENworks 11 Server Installation Guide.
Stop all the ZENworks Services on all the ZENworks Servers in the Management Zone.
On Windows: Do the following
Execute the following command at the server prompt:
novell-zenworks-configure -c Stop
Enter the number next to the Stop action.
On Linux: Do the following:
Execute the following command at the server prompt:
/opt/novell/zenworks/bin/novell-zenworks-configure -c Stop
Enter the number next to the Stop action.
Move the data from MSDB1 to MSDB2. For more information about moving the data, see the MS SQL database documentation.