External Database Maintenance
35
313
n
ov
do
cx (e
n)
16
Ap
ril 20
10
35
External Database Maintenance
Section 35.1, “Backing Up the External Sybase Database,” on page 313
Section 35.2, “Restoring the External Sybase Database,” on page 322
Section 35.3, “Moving the Data from One External Sybase Database to another External
Sybase Database,” on page 323
Section 35.4, “Moving the Data from an External OEM Sybase Database to an Embedded
Sybase Database,” on page 325
Section 35.5, “Configuring the ZENworks Server to Point to the New MS SQL Database
Containing Data Moved from Another MS SQL Database,” on page 327
Section 35.6, “Configuring the ZENworks Server to Point to the New Oracle Database
Containing Data Moved from Another Oracle Database,” on page 328
35.1 Backing Up the External Sybase Database
When an external Sybase database (Remote OEM Sybase or Remote Sybase SQL Anywhere) has
been installed by using the ZENworks 10 Configuration Management installation media, you can
back it up to a directory on the local machine or to a network location.
Section 35.1.1, “Backing Up the External Sybase Database on a Windows or Linux Server,” on
page 313
Section 35.1.2, “Backing up the External Sybase Database Running on a Windows Server to a
Network Location on a Remote Windows Machine,” on page 316
Section 35.1.3, “Backing up the External Sybase Database Running on a Linux Server to a
Network Location on a Remote Linux Machine,” on page 319
35.1.1 Backing Up the External Sybase Database on a
Windows or Linux Server
Perform the following steps on the Windows or Linux server that has the external Sybase database
installed and running:
1
Launch the DBISQL utility:
1a
At the command prompt, go to the
%ZENWORKS_HOME%\sybase\ASA\win32
directory on
Windows or to the
/opt/novell/zenworks/share/sybase/bin32s
directory on
Linux.
1b
Enter the
dbisql
command.
1c
In the
Identification
tab, specify the database credentials.
1d
Click the
Database
tab, then specify the name of database service that is currently
running.
1e
Click
OK
.