General Considerations for CA ARCserve Backup and the Agent
Appendix A: Troubleshooting and Disaster Recovery 87
However, when a large remote SQL Server database is restored, particularly
when it involves creation of SQL data files, such as when you restore to a
different SQL Server, the Agent for Microsoft SQL cannot reply immediately
because SQL Server takes some time to create the files, and the agent must
wait for this to complete before it can respond.
The default timeout value is set to 1200 seconds (20 minutes). This should
be extended when you restore a large SQL Server database involving large
data files. A large SQL Server database (60 GB) might require the value to be
as long as 7200 seconds (120 minutes). In general, the default value (1200)
can handle most database restores, as well as network errors. However, if
you have a network timeout error on a large SQL Server database restore
operation, you should increase the time-out value. After the restore is done,
you should reset the value to 1200.
The SendTimeOut and ReceiveTimeOut keys can be found on the CA
ARCserve Backup Server machine under:
HKEY_LOCAL_MACHINE\SOFTWARE\ComputerAssociates\CA ARCserve
Backup\Base\Task\Remote
Note:
These settings apply to all agents which operate under the Universal
Agent service.
■
Backup with Compare and Backup with Scan Tape are not performed on
agent sessions.
■
The CA ARCserve Backup Manager and the CA ARCserve Backup Universal
Agent must be stopped before uninstalling and reinstalling CA ARCserve
Backup Agent for Microsoft SQL Server if they are installed on the same
server as the agent.
■
If a TCP/IP connection fails, or if the Port number has changed, restart the
Universal Agent Service.
■
To support pass-through authentication of account logon events for
computers in a domain, the NetLogon service must be started.
■
In a cluster environment, run the Universal Agent as a Domain
Administrator, rather than as LocalSystem. This is to prevent a conflict of
access privileges between the agent and Microsoft SQL Server when backing
up Microsoft SQL Server databases.
