Agent Activity Log
Chapter 1: Introducing the Agent 17
Feature/Function
Microsoft SQL Server Version
SQL 7.0 SQL
2000
SQL
2005
SQL
2008
Full-text search catalogs
(see page
110)
No
No
Yes
Yes
Resource database
No
No
Yes
Yes
Full database backups
(see page
118)
No
Yes
Yes
Yes
Differential database backups
(see
page 119)
No
Yes
Yes
Yes
Partial database backups
(see page
122)
No
No
Yes
Yes
Torn Page Repair
No
No
Yes
Yes
Include checksum generated by SQL
Server
No
No
Yes
Yes
Continue restore after checksum
failure
No
No
Yes
Yes
Agent Activity Log
The Agent for Microsoft SQL Server generates a log with information about
backup or restore jobs and their status. This Activity log is called sqlpagw.log and
is located in the directory in which the agent has been installed. If errors appear
in the CA ARCserve Backup job logs, check the Activity log for more information
about why the errors occurred.
Online Backup of SAP R/3 Databases
When you use Microsoft SQL Server 7.0 or later as the database server for SAP
R/3, you can perform an online backup of SAP R/3 databases using the Agent for
Microsoft SQL Server. A separate agent for SAP R/3 is not required. The online
backup procedure is the same as it is with any other database in the Microsoft
SQL Server.
Note:
You cannot perform offline backups of SAP R/3 databases in Microsoft SQL
Server using the Agent for Microsoft SQL Server.
