Chat now with support
Chat with Support

NetVault Plug-in for Sybase 11.4.5 - User Guide

Backing up data

•
Important considerations
•
Selecting data for a backup
•
Setting backup options
•
Finalizing and submitting the job
•
Using other backup procedures

Important considerations

Because the plug-in backs up databases on the SAP ASE Server, which is constantly running, the plug-in does not back up the SAP ASE database startup parameters and environmental settings. Therefore, one of the following must take place to back up these necessary files:

•
Take the SAP ASE Database offline and perform a backup of the database: With the database offline, these files are not active and are included in a standard backup of the database.
•
If a failure of the SAP ASE Database occurs, perform a backup of these files before attempting a recovery of the database: In this case, back up the files located in: “.../opt/sybase”

Selecting data for a backup

You must use sets — Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set — to create a backup job.

Backup Selection Sets are essential for Incremental and Differential Backups. Create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Differential Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Differential Backup. For more information, see the Quest NetVault Backup Administrator’s Guide.

 
* 
TIP: To use an existing set, click Create Backup Job, and select the set from the Selections list.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
Assign a descriptive name that lets you easily identify the job when monitoring its progress or restoring data. The job name can contain alphanumeric and nonalphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
3
Next to the Selections list, click Create New.
4
In the list of plug-ins, open Plug‑in for SAP ASE to display the SAP ASE Server.
5
Do one of the following:
•
If you want to back up the entire SAP ASE Server, select the displayed item, and skip to Step 10.
•
If you want to perform a more detailed backup, that is, select individual SAP ASE databases for inclusion, proceed to Step 6.
6
To open the SAP ASE Server, double-click it.
7
On the Sybase Login dialog box, enter the required login information so that you can browse the SAP ASE Server’s individual database items:
•
Account Name: Enter the account name assigned to the SAP ASE Server during its creation; that is, the account name that allows access to the SAP ASE Server for the backup or restore of its database information. The value entered as the Default Account Name in the Configure dialog box is displayed by default.
•
Password: Enter the password that corresponds to the account name entered in the previous field.
8
Click OK.
9
In the list of individual database components that is displayed, select the applicable database items for inclusion in a backup.
10
Click Save, enter a name in the Create New Set dialog box, and click Save.
The name can contain alphanumeric and nonalphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.

Setting backup options

The next step involves creating the Backup Options Set or selecting an existing one.

 
* 
TIP: To use an existing set, in the Plugin Options list, select the set that you want to use.
1
Next to the Plugin Options list, click Create New.
2
In the Sybase Backup Type section of the Options tab, select the type of backup to perform:
•
Full: Performs a complete backup of selected data. This option is the equivalent to the following SAP ASE ISQL command: DUMP DATABASE
•
Incremental: Performs a backup of the transaction log for the selected items. After the backup, these logs are truncated. This option is the equivalent to the following SAP ASE ISQL command: DUMP TRANSACTION. For more information, see Using Incremental Backups.
•
Differential: Performs a backup of the transaction log for the selected items. This option is the equivalent to the following SAP ASE ISQL command: DUMP TRANSACTION WITH NO_TRUNCATE. For more information, see Using Differential Backups.
 
* 
IMPORTANT: Before performing an Incremental or Differential Backup, a Full Backup of the same data must be performed.

For information about how an Incremental or Differential Backup sequence affects the way restores are performed, see Restoring Incremental and Differential Backups.

An Incremental or Differential Backup of a database is only possible when the data and log are configured to reside on different devices. An error occurs if both data and log reside on the same device and an Incremental or Differential Backup is attempted. This error occurs because the NetVault Backup Incremental and Differential Backups are equivalent to the Dump Transaction command of SAP ASE that backs up the transaction log. SAP ASE Server only supports the Dump Transaction command if the transaction logs reside on a different device than the data resides on.
3
To save the set, click Save.
4
In the Create New Set dialog box, specify a name for the set, and click Save.
The name can contain alphanumeric and nonalphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating