General Considerations for CA ARCserve Backup and the Agent
86 Agent for Microsoft SQL Server Guide
General Considerations for CA ARCserve Backup and the
Agent
The following general considerations apply to CA ARCserve Backup and the
Agent for Microsoft SQL Server:
■
CA ARCserve Backup does not support special characters (for example, /, \,
*, <, >, or ?) in file names, FileGroup names, and database names. The CA
ARCserve Backup Agent for Microsoft SQL does not support brackets ( [ ] ) in
database, FileGroup, or logical file names.
■
When restoring a file or FileGroup, if there are no log sessions to follow the
file or FileGroup session, CA ARCserve Backup cannot verify if the file was
modified. As a result, it cannot identify the final recovery completion state.
By default, it chooses the option Leave database non-operational, but able to
restore additional transaction logs. Each time you back up a file or FileGroup,
ensure that you back up a log immediately afterwards.The "Backup
Transaction Log After Database" option is recommended.
■
The Microsoft Windows Small Business Server 2003 SharePoint database is
stored in a Microsoft SQL Server Desktop Engine (MSDE) instance. The
SharePoint instance does not support SQL-native authentication. You must
use Windows authentication for this database instance.
■
When you log into Microsoft SQL Server using Windows authentication to
perform Virtual Devices-based backup and restore operations, you must
have system administrator rights for Microsoft SQL Server. This is a
Microsoft requirement.
■
The CA ARCserve Backup Agent for Microsoft SQL Server does not support
backing up and restoring SQL Server databases where the sum of the
characters representing the instance name, the database name, the file
group name, and the data file name exceeds 170 characters.
■
Microsoft SQL Server 2008 introduces a data type called FILESTREAM, which
stores large blocks of binary data in files on disk. FILESTREAM data is stored
in logical SQL Server files that exist as directories on disk. SQL Server does
not properly report the size of FILESTREAM data, and the size of this data is
calculated directly by the Agent. If this data includes a large number of
records, this calculation may be very time-consuming and cause delays
when querying database properties during Browse and Backup.
■
If an error message appears when you restore and move a database that
uses a long file name, rename the database files using shorter file names and
perform the restore operation on the database.
■
When backing up or restoring a SQL Server database, the SendTimeOut and
ReceiveTimeOut parameters define how long the CA ARCserve Backup
Server waits for a response from the agent. This prevents problems such as
network errors from causing jobs to wait forever for a response that might
not come. Once this time-out period expires, the waiting job fails with a
network error.
