Contents 7
Contents
Chapter 1: Introducing the Agent
11
Introduction
..................................................................................
11
Architectural Overview
........................................................................
12
How the Agent Works
.........................................................................
13
How a Backup Request Works
.............................................................
13
How a Restore Request Works
.............................................................
14
How Data Flows During Backup
............................................................
14
Agent Services
...........................................................................
14
Access Requirements
.....................................................................
15
Backup and Restore Options
...............................................................
15
Microsoft SQL - CA ARCserve Backup Compatibility Matrix
.......................................
16
Agent Activity Log
............................................................................
17
Online Backup of SAP R/3 Databases
..........................................................
17
Agent for ARCserve Database
.................................................................
18
Chapter 2: Installing the Agent
21
Installation Prerequisites
......................................................................
21
Basic Prerequisites
........................................................................
21
Microsoft SQL Server 2000, 2005 and 2008 Cluster Environment Prerequisites
................
21
Installation Considerations
....................................................................
23
Install the Agent
..............................................................................
24
Install the Agent in a Standard Microsoft SQL Server Environment
...........................
24
Install the Agent in a Microsoft SQL Server 2000 or Later Cluster Environment
................
25
Post-Installation Procedures
...................................................................
25
Configure Backup and Restore Parameters for the Agent for Microsoft SQL Server
.............
26
How to Uninstall the CA ARCserve Backup Agent for Microsoft SQL
...............................
28
Chapter 3: Backing Up Microsoft SQL Server Databases
29
Backup Overview
.............................................................................
29
Backup Manager Agent Options
............................................................
30
Dynamic and Explicit Job Packaging
............................................................
38
Dynamic Job Packaging
...................................................................
39
Mark Objects for Dynamic Job Packaging
...................................................
40
Explicit Job Packaging
.....................................................................
40
Mark Objects for Explicit Job Packaging
.....................................................
41
Back Up a Database
..........................................................................
42