Chapter 4: Restoring Microsoft SQL Server Databases 45
Chapter 4: Restoring Microsoft SQL
Server Databases
This section contains information about restoring databases and Transaction logs
using CA ARCserve Backup, the Agent for Microsoft SQL Server, and Microsoft
SQL Server 7.0, Microsoft SQL Server 2000, Microsoft SQL Server 2005 and
Microsoft SQL Server 2008.
This section contains the following topics:
Restore Options
(see page 46)
Database File Options
(see page 54)
Restore Databases Using Restore by Tree Method
(see page 57)
Restore Databases Using Restore by Session Method
(see page 60)
SQL Agent Filter Options
(see page 63)
Restore to Alternate Disk Locations Using Automatic Selection
(see page 63)
Restore to Alternate Disk Locations by Individual Session
(see page 64)
Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008
(see page 68)
Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008
Enterprise, Data Center, or Developer Editions
(see page 70)