Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 8

Chapter 4: Restoring Microsoft SQL Server Databases 45 Restore Options 46 Automatic Selection Option 47 Restore Types 47 Log Point-in-Time Restore Options 50 Recovery Completion State Options 51 Database Consistency Check (DBCC) Options 52 Force Restore to use Named Pipes 53 Continue Restore After Checksum Failure 53 Miscellaneous 53 Database File Options 54 Restore Databases Using Restore by Tree Method 57 Restore Databases Using Restore by Session Method 60 SQL Agent Filter Options 63 Restore to Alternate Disk Locations Using Automatic Selection 63 Restore to Alternate Disk Locations by Individual Session 64 Restore by Session Using a Single Restore Job 64 Restore by Session Using a Separate Job for Each Session 65 Restore by Tree Using a Separate Job for Each Session 66 Perform an Offline Torn Page Restore Using Microsoft SQL Server 2005 or 2008 68 Perform an Online Torn Page Restore Using Microsoft SQL Server 2005 or 2008 Enterprise, Data Center, or Developer Editions 70 Chapter 5: Backing Up and Restoring in Cluster Environments 73 Backup and Restore Considerations in Microsoft SQL Server Cluster Environments 73 Microsoft SQL Server 2000, 2005 and 2008 Cluster Environment Prerequisites 74 Microsoft SQL Server 2000, 2005, or 2008 Cluster Environment Backups 74 Select Server, Protocol, Security, and Backup Type 74 Select Backup Destination, Schedule, and Submit the Job 76 Restore by Tree in Microsoft SQL Server 2000, 2005 or 2008 Cluster Environments 77 Restore by Session in Microsoft SQL Server 2000, 2005 or 2008 Environments 80 Perform Disaster Recovery in Microsoft SQL Server 2000, 2005, or 2008 Cluster Environments .... 83 Appendix A: Troubleshooting and Disaster Recovery 85 General Considerations for CA ARCserve Backup and the Agent 86 Upgrade Considerations for the Agent for Microsoft SQL 88 Skip or Include Database Files in Backups 89 Agent and CA ARCserve Backup Error Messages 91 Microsoft SQL Server Error Messages 93 Limitations of Microsoft SQL Server Database 95 Replication of Microsoft SQL Server 95 8 Agent for Microsoft SQL Server Guide