Home » Computer Associates Manuals » Computer Software » Computer Associates SQLSTQ99000600 » Manual Viewer

Computer Associates SQLSTQ99000600 Microsoft SQL Guide - Page 3

CA Product References, Backup Agent for Novell Open Enterprise Server for Linux - oracle

Get Computer Associates SQLSTQ99000600 - Unicenter SQL-Station 6.0.0 PDF manuals and user guides

UPC - 757943257441

View all Computer Associates SQLSTQ99000600 manuals

Add to My Manuals
Save this manual to your list of manuals

Page 3 highlights

CA Product References This documentation set references the following CA products: ■ BrightStor® Enterprise Backup ■ CA Antivirus ■ CA ARCserve® Assured Recovery™ ■ CA ARCserve® Backup Agent for Advantage™ Ingres® ■ CA ARCserve® Backup Agent for Novell Open Enterprise Server for Linux ■ CA ARCserve® Backup Agent for Open Files on NetWare ■ CA ARCserve® Backup Agent for Open Files on Windows ■ CA ARCserve® Backup Client Agent for FreeBSD ■ CA ARCserve® Backup Client Agent for Linux ■ CA ARCserve® Backup Client Agent for Mainframe Linux ■ CA ARCserve® Backup Client Agent for NetWare ■ CA ARCserve® Backup Client Agent for UNIX ■ CA ARCserve® Backup Client Agent for Windows ■ CA ARCserve® Backup Enterprise Option for AS/400 ■ CA ARCserve® Backup Enterprise Option for Open VMS ■ CA ARCserve® Backup for Microsoft Windows Essential Business Server ■ CA ARCserve® Backup for Windows ■ CA ARCserve® Backup for Windows Agent for IBM Informix ■ CA ARCserve® Backup for Windows Agent for Lotus Domino ■ CA ARCserve® Backup for Windows Agent for Microsoft Exchange Server ■ CA ARCserve® Backup for Windows Agent for Microsoft SharePoint Server ■ CA ARCserve® Backup for Windows Agent for Microsoft SQL Server ■ CA ARCserve® Backup for Windows Agent for Oracle ■ CA ARCserve® Backup for Windows Agent for Sybase ■ CA ARCserve® Backup for Windows Agent for Virtual Machines ■ CA ARCserve® Backup for Windows Disaster Recovery Option ■ CA ARCserve® Backup for Windows Enterprise Module

Section	Page
CA ARCserve Backup for Windows Agent for Microsoft SQL Server Guide	1
Contents	7
1: Introducing the Agent	11
Introduction	11
Architectural Overview	12
How the Agent Works	13
How a Backup Request Works	13
How a Restore Request Works	14
How Data Flows During Backup	14
Agent Services	14
Access Requirements	15
Backup and Restore Options	15
Microsoft SQL - CA ARCserve Backup Compatibility Matrix	16
Agent Activity Log	17
Online Backup of SAP R/3 Databases	17
Agent for ARCserve Database	18
2: Installing the Agent	21
Installation Prerequisites	21
Basic Prerequisites	21
Microsoft SQL Server 2000, 2005 and 2008 Cluster Environment Prerequisites	21
Installation Considerations	23
Install the Agent	24
Install the Agent in a Standard Microsoft SQL Server Environment	24
Install the Agent in a Microsoft SQL Server 2000 or Later Cluster Environment	25
Post-Installation Procedures	25
Configure Backup and Restore Parameters for the Agent for Microsoft SQL Server	26
How to Uninstall the CA ARCserve Backup Agent for Microsoft SQL	28
3: Backing Up Microsoft SQL Server Databases	29
Backup Overview	29
Backup Manager Agent Options	30
Agent Options (Database Level)	31
Agent Options (Global Options)	32
Backup Methods	32
Database Subset	34
Log Truncation Options	36
Database Consistency Check (DBCC) Options	36
Other Options	38
Dynamic and Explicit Job Packaging	38
Dynamic Job Packaging	39
Mark Objects for Dynamic Job Packaging	40
Explicit Job Packaging	40
Mark Objects for Explicit Job Packaging	41
Back Up a Database	42
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
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
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
Configure Agent Behavior for Databases Ineligible for Backup	96
Additional Database Status Considerations	98
Microsoft SQL Server Disaster Recovery	98
The Master Database	98
Potential Restore Problems	99
Suggested Database Restore Sequence	99
Disaster Recovery Scenario	100
B: Configuring Microsoft SQL Server Security Settings	101
Types of Microsoft SQL Server Authentication	101
Authentication Requirements	101
How User Authentication Is Changed	102
Check or Change the Microsoft SQL Server Authentication Method	102
Update the Agent Account Configuration	103
Check and Change the ODBC Settings	104
Update the Backup Manager	105
C: Backup and Recovery Best Practices	107
Microsoft SQL Server Database Basics	108
About Files and FileGroups	108
Example	109
Full-Text Search Catalogs	110
FILESTREAM Data	110
Performance Improvement Tips	111
Partitioning	112
Database Mirroring	112
Recovery Models	113
System Databases	114
Backup and Restore Considerations in Microsoft SQL Server Cluster Environments	115
Backup Concepts	115
Backup Considerations	116
Required Full Backup	116
Database Consistency Checks	117
Backup Strategy Recommendations	117
Full Backups	118
Differential Backups	119
Differential Backup Timing	119
Transaction Log Backups	120
Truncate Transaction Logs	121
Files and FileGroup Backups	121
How the Create Index Statement Impacts File and FileGroup Backups	122
Partial Backups	122
Restore Overview	123
Restore Types and Methods	124
Checklists for Dependencies, by Type	125
Database Restore Dependency Checklist	125
Transaction Log Restore Dependency Checklist	126
Files and FileGroups Restore Dependency Checklist-MSSQLSvrWSPW	127
Partial Restore Dependency Checklist	128
Torn Page Repair Dependency Checklist	129
Microsoft SQL Server Disaster Recovery Elements	131
Restore Master Databases	132

Match case Limit results 1 per page

CA Product References

This documentation set references the following CA products:

■

BrightStor

Enterprise Backup

■

CA Antivirus

■

CA ARCserve

Assured Recovery

™

■

CA ARCserve

Backup Agent for Advantage

™

Ingres

■

CA ARCserve

Backup Agent for Novell Open Enterprise Server for Linux

■

CA ARCserve

Backup Agent for Open Files on NetWare

■

CA ARCserve

Backup Agent for Open Files on Windows

■

CA ARCserve

Backup Client Agent for FreeBSD

■

CA ARCserve

Backup Client Agent for Linux

■

CA ARCserve

Backup Client Agent for Mainframe Linux

■

CA ARCserve

Backup Client Agent for NetWare

■

CA ARCserve

Backup Client Agent for UNIX

■

CA ARCserve

Backup Client Agent for Windows

■

CA ARCserve

Backup Enterprise Option for AS/400

■

CA ARCserve

Backup Enterprise Option for Open VMS

■

CA ARCserve

Backup for Microsoft Windows Essential Business Server

■

CA ARCserve

Backup for Windows

■

CA ARCserve

Backup for Windows Agent for IBM Informix

■

CA ARCserve

Backup for Windows Agent for Lotus Domino

■

CA ARCserve

Backup for Windows Agent for Microsoft Exchange Server

■

CA ARCserve

Backup for Windows Agent for Microsoft SharePoint Server

■

CA ARCserve

Backup for Windows Agent for Microsoft SQL Server

■

CA ARCserve

Backup for Windows Agent for Oracle

■

CA ARCserve

Backup for Windows Agent for Sybase

■

CA ARCserve

Backup for Windows Agent for Virtual Machines

■

CA ARCserve

Backup for Windows Disaster Recovery Option

■

CA ARCserve

Backup for Windows Enterprise Module