Performing Sybase On-Demand Backups

You can use an external input file to specify the content when you perform an On-Demand backup.

Note

This feature applies to configuration that use Sybase ASE version 15.7 ESD #2 (SP100) or later.

Create an On-Demand subclient by using the command line interface. For information on how to create the subclient, see Creating an On-Demand Subclient.
Set 'enable concurrent dump tran' to 0.
Create a text file (called a directive file) that contains the list of databases that you want to back up.

Note

The file must contain one database on each line and must contain all the databases to back up.

For example

An input file with 3 databases:
```
db1
db2
db3
```

From the CommCell Browser, expand Client Computers > client > Sybase > instance.
Right-click the On-Demand subclient and click Backup.
On the Backup Options for Subclient dialog box:
1. In the Directive File box, type or browse to the full path and name to the directive file that you created.
2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.
  
  Note
  
  If you selected Schedule, set up the schedule.
  
  For information on configuring a backup schedule, see Schedule Backups.
Click OK to close the Backup Options dialog box.

Note

You can configure the Sybase software to run transaction log dumps even when a full or cumulative dump is running. When this feature is enabled and you run a restore, there is a possibility that the transaction log load order goes out of sequence. The following error may occur:
```
Specified file 'dump device' is out of sequence. Current time stamp is Nov 3 2015 1:59:59:423AM while dump was from Nov 3 2015 1:59:59:296AM.
```
Alternatively, you can run a Sybase on-demand backup operation from the command line. For more information, see Running an On-Demand Backup Operation from the Command Line.