beautypg.com

Using agent backup scripts (tape backups), Coding rules for scripts – HP XP Racks User Manual

Page 403

background image

x : Action not permitted.

Table 22 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 410

Creating an application replica

, page 388

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

403