How the Agent Works
14 Agent for Microsoft SQL Server Guide
How a Restore Request Works
Restore jobs use the following process:
1.
You issue a restore command from CA ARCserve Backup.
2.
CA ARCserve Backup informs the agent of the restore job.
3.
The agent instructs Microsoft SQL Server to prepare to receive the data.
4.
CA ARCserve Backup accesses storage media and begins restoring data.
5.
CA ARCserve Backup transfers data to the agent.
6.
The agent transfers data to Microsoft SQL Server.
7.
Microsoft SQL Server recovers the database.
How Data Flows During Backup
The following steps describe the data flow when CA ARCserve Backup uses the
Agent for Microsoft SQL Server to back up a Microsoft SQL Server instance:
1.
CA ARCserve Backup sends a request to the agent for a database.
2.
The agent instructs Microsoft SQL Server to perform a backup of a particular
database or log.
3.
Microsoft SQL Server returns the data from the database in multiple chunks
to the agent, one chunk at a time.
4.
The agent receives the data chunks from Microsoft SQL Server and transfers
them to CA ARCserve Backup.
5.
CA ARCserve Backup writes the data chunks to media.
These steps are repeated until there is no more data to be backed up. The agent
and the Microsoft SQL Server backup function guarantee the consistency and
accuracy of the data being backed up.
Agent Services
The Agent for Microsoft SQL Server runs within the context of the CA ARCserve
Universal Agent Service. This service is shared with other agents, providing a
single point of access for backup and restore operations. The service starts
automatically after the installation is completed, and dynamically recognizes the
addition of new agents as they are installed.
