Appendix C: Backup and Recovery Best Practices 107
Appendix C: Backup and Recovery Best
Practices
Data loss can be limited to a file on a single disk drive or encompass your entire
data center. Ideally, you should consider a strategy that protects each database
you maintain. Consider database size and activity as well as business importance
as you design your strategy. The decisions you make during this critical analysis
phase govern the backup and restore options available in CA ARCserve Backup.
The following information is provided to start your planning efforts.
Important!
You should refer to the Microsoft SQL Server documentation for
complete information on configuring SQL Server databases for optimal
protection.
This section contains the following topics:
Microsoft SQL Server Database Basics
(see page 108)
Backup Concepts
(see page 115)
Restore Overview
(see page 123)
