Microsoft SQL - CA ARCserve Backup Compatibility Matrix
16 Agent for Microsoft SQL Server Guide
Restore options enable you to do the following:
■
Restore data and transaction logs
■
Automatically determine a sequence of backups to restore, to produce a live,
consistent database with a single restore job
■
Use transaction log restores to restore the data to a specific point in time, or
to the start or end of a named transaction
■
Restore the entire database or a selected subset of the database files and
FileGroups
■
Restore a selected subset of the database as a new database
■
Perform a Torn Page Repair of a database, even while it is online
■
Leave the database in a restricted access mode
■
Preserve or clear the replication settings of the restored database
■
Change the physical location on disk of data and transaction log files
■
Check only the physical consistency of a database after restore is complete
■
Override any inconsistencies found with SQL Server’s native error checking
information
For more information about restore options, see the section,
Restoring Microsoft
SQL Server Databases
(see page 45).
Microsoft SQL - CA ARCserve Backup Compatibility Matrix
CA ARCserve Backup supports features and functions introduced in various
Microsoft SQL Server versions, as follows:
Feature/Function
Microsoft SQL Server Version
SQL 7.0 SQL
2000
SQL
2005
SQL
2008
Named Pipes
Yes
Yes
No
No
Multiple Instance Support
No
Yes
Yes
Yes
Partitioning
No
No
Yes
Yes
Database Mirroring
No
No
Yes
Yes
FILESTREAM
No
No
No
Yes
File and FileGroup backups
(see page
121)
No
Yes
Yes
Yes
Cluster Environments
(see page 73) No
Yes
Yes
Yes
