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
Содержание ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE STRUCTURE
Страница 4: ...4 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 18: ...18 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 26: ...26 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 60: ...60 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 64: ...64 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 70: ...70 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 78: ...78 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 98: ...98 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 118: ...118 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 138: ...138 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 140: ...140 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 142: ...142 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 144: ...144 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 162: ...162 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 164: ...164 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 168: ...168 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 170: ...170 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 190: ...190 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 212: ...212 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 214: ...214 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 224: ...224 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 234: ...234 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 236: ...236 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 242: ...242 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 250: ...250 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 256: ...256 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 282: ...282 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 284: ...284 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 290: ...290 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 292: ...292 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 330: ...330 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 338: ...338 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 340: ...340 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 348: ...348 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 360: ...360 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 362: ...362 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 368: ...368 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 374: ...374 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...