Loading...

Specifying Sybase Databases for On-Demand Backups Using the SnapProtect Command Line Interface

Use XML to create Sybase subclients and run On-Demand backups. Run the operation from the command line, or automate configuration by combining command line operations in a script.

The XML parameters can be included in the XML file, or specified on the command line when they frequently change. For more information on command line parameters and XML elements, see Command Line - Syntax.

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

Note: If you use Sybase ASE version 15.7 ESD #2 (SP100) or later, you can configure the Sybase software to run transaction log dumps even when a full or cumulative dump is running. Set 'enable concurrent dump tran' to 1 to use this feature. 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.

Procedure

  1. On the Sybase Agent host, run the qlogin command to log on to the CommServe computer.
  2. Download the  create_subclient_template.xml file to the computer where you will run the command.

    For information on supported subclient XML parameters, see Available XML Parameters for Sybase Subclient Configuration.

  3. On the command line, go to Software_Installation_Directory/Base and type the following command.

    qoperation execute -af xml_path\create_subclient_template.xml -appName 'Sybase' -clientName 'client_name' -instanceName 'instance_name' -subclientName 'subclient_name' -dataBackupStoragePolicy/storagePolicyName 'storage_policy_name' -onDemandSubClient true

  4. On the client computer where you will create the subclient to backup, create a text 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.

    Example

    An input file with 3 databases

    db1
    db2
    db3

  5. Download the backup_template.xml file to the computer where you will run the command.
  6. On the command line, go to Software_Installation_Directory/Base and type the following command.

    qoperation execute -af xml_path\backup_template.xml -appName 'Sybase' -clientName 'client_name' -instanceName 'instance_name' -subclientName 'subclient_name' –ondemandinputfile c:\DatabaseFile.txt –backupLevel FULL

  7. Run the qlogout command to log off the CommServe computer.

Examples

Create the subclient

qoperation execute -af xml_path\create_subclient_template.xml appName 'Sybase Database' -instanceName S155syb6 -clientName sybserver6 -subclientName ondemand_sub -dataBackupStoragePolicy/storagePolicyName sybase_sp -onDemandSubClient true

Perform the backup

qoperation execute -af xml_path\backup_template.xml -appName 'Sybase Database' -clientName sybserver6 -instanceName S155syb6 -subclientName ondemand_sub -ondemandinputfile /BOL/ondemand/list.txt -backupLevel FULL