SQL Server 2000 Backup and Recovery

Plan for an implement a sound SQL Server 2000 data protection solution. SQL Server 2000 BAckup & Recovery explains in detail how to develop a strategy based on your business requirements, select hardware and software, plan for data storage, perform backups, and execute data restore procedures. The focus is on practical, real-world information that you can immediately apply in your own environment. Case studies and scenarios illustrate how to apply all the methods presented in the book. Increase SQL Server performance and provide high levels of data protection with help from this practical resource.

• Create a valid data protection plan based on business requirements
  
• Configure and manage security and data protection in Windows NT/2000
  
• Understand SWL Server 2000 architecture, including transaction logs, concurrency, locking, and data stroage features
  
• Determine the best hardware and software for your backup and recovery operations
  
• Plan for and perform full, differential, and transaction log backups
  
• Design data storage solutions using RAID, filegroups, and other SQL Server 2000 technologies
  
• Develop restore plans to accomodate everything from minor data loss to complete system failures
  
• Implement advanced data protection to increase realibility and uptime using replication, standby servers (log-shipping), and fail-over clustering
  

Contents

Developing a data protection strategy

• Evaluating data protection requirements
  
• Developing the data protection plan
  

• Windows NT/2000 security and data protection
  
• SQL server 2000 architecture
  
• Evaluating data protection solutions
  

• Performing database backups
  
• Restoring databases
  
• Backup and recovery scenarios, tools, and techniques
  

• Advanced data protection: replication, log-shipping, and clustering
  
• Case studies: solving business challenges

Resources for more information

Index