Using agent backup scripts (tape backups), Coding rules for scripts – HP XP P9000 Command View Advanced Edition Software User Manual

Page 391

Advertising
background image

x : Action not permitted.

Table 21 SQL Server database type and user actions supported

SQL Server database type

User action

User data-
base

System database

tempdb

model

msdb

master

•

x

•

•

•

Create replicas

o

o

o

o

o

Update task information

o

o

o

o

o

Update host information

o

o

o

o

o

Configure Application
Agent Settings

o

x

o

o

o

Restore replicas

Legend:

• : Action permitted (involving operations on the database)

o : Action permitted (not involving operations on the database)

x : Action not permitted.

Using Agent backup scripts (tape backups)

This topic outlines how to use scripts to perform tape backups from Replication Manager.

Because Replication Manager performs tape backups using a separate backup management product,
you must configure a script to execute the necessary commands. Using an agent user script in
conjunction with a batch command file, you can back up a database to tape from the primary volume
using the secondary volume in a single operation.

This topic includes the following information:

• Coding rules for scripts
• Script entries
• Agent script example
• Environment variables
• Unmounting after an automatic mount
• Batch command file example
• Preparing the user script and batch command file

Related topics

• Performing tape backups and restores

, page 398

• Creating an application replica

, page 376

Coding rules for scripts

To specify a command in a user script, you must follow the scripting rules. The script should consist
of two sections:

PRE_PROC

: Pre-processing specified by the user (before the backup command is issued).

User Guide

391

Advertising
This manual is related to the following products: