Embedded Database Maintenance
297
n
ov
do
cx (e
n)
16
Ap
ril 20
10
34.3.2 Backing up the Embedded Sybase SQL Anywhere
Database Running on a Windows Server to a Network Location
on a Remote Windows Machine
To back up an embedded Sybase SQL Anywhere database that is installed and running on a
Windows server to a network location on another Windows machine, you need a local machine and
a remote machine. The local machine is a Windows server with the ZENworks server components
and the embedded Sybase SQL Anywhere database installed. The remote machine is a Windows
machine that has the network location to which you want to back up the database.
1
Perform the following steps on the local machine:
1a
Create an administrative user and specify a password.
For example, you could specify the administrative username as
Administrator
and the
password as
novell
.
1b
From the desktop
Start
menu, click
Settings
, click
Control Panel
, double-click
Administrative Tools
, then double-click
Services
.
1c
Right-click the
Novell ZENworks Datastore
service, then click
Properties
.
1d
Click the
Log On
tab.
1e
Select
This account
, then specify the name and the password of the administrative user
created in
Step 1a
.
For example, specify the user as
Administrator
and the password as
novell
.
1f
Click
OK
.
2
Perform the following steps on the remote machine that has the network location where you
want to save the backup:
2a
Create an account with the same credentials as the user you created in
Step 1a
.
For example, specify user as
Administrator
and password as
novell
.
2b
Provide Read/Write permission on the network location to the user.
To immediately back up the database, continue with
Step 3
. To schedule the backup to run
at a specific time every day or on specific days of a month, skip to
Step 4
.
3
(Conditional) To immediately back up the database to the network location on the remote
machine, enter the following command at the command prompt:
zman database-backup
\\
IP_address_of_the_remote_machine
\
backup_directory\custom_directory
Where
\\
IP_address_of_the_remote_machine
\
backup_directory
is the network
location on the remote machine and
custom_directory_name
is a name that you specify for a
directory to be newly created by zman and into which the database files are to be backed up.
4
(Conditional) To schedule the backup:
4a
Create a schedule file,
backupschedule.sql
, with the following contents:
CREATE EVENT
backup_schedule_name
SCHEDULE
specify_the_schedule
A sample schedule file to back up the database at a 11 p.m. every day is as follows:
CREATE EVENT ZENDBBackup
