Backup and Recovery Best Practices for Microsoft SQL Server 2005

To help you choose from among the available configuration options and backup and recovery procedures, HP has conducted extensive laboratory tests to determine best practices.
This paper discusses those test results so that users can understand the options and the limitations of implementing backup and recovery using Linear Tape-Open (LTO) tape, disk-to-disk, and virtual tape devices. The audience for this paper is HP users in an enterprise environment currently running or planning to run SQL Server 2005.

The paper discusses:

• Best practice recommendations encompassing configuration, design, and deployment
• Backup and recovery recommendations for the integration of Data Protector Software and Microsoft SQL Server 2005
• Backup and recovery recommendations for the LTO tape, the disk-to-disk, and the virtual tape methodologies
• The impact on database performance and throughput for each of the methodologies: LTO tape, disk-to-disk, and virtual tape
• General recommendations for selecting which backup and recovery method to use
• Supporting configuration recommendations for HP servers and for HP StorageWorks 8100 Enterprise Virtual Array (EVA8100) disk array
• Recommendations for the use of parallel backup and restore operations, and the impact of multiple streams and device concurrency on overall backup performance

Click here to Download

Related Magazine :

1. Symantec Backup Exec Quick Recovery and Off-Host Backup Solutions for Microsoft Exchange Server 2003 and Microsoft SQL Server
2. High availability for SQL Server 2005 using array-based replication and host-based mirroring technologies
3. Best practices for using Microsoft SQL Server 2008 Data Compression with HP ProLiant and Integrity servers and HP StorageWorks EVA8×00
4. Easing the Migration to Microsoft SQL Server 2005
5. Top Reasons to Upgrade to Symantec Backup Exec 12.5 and Backup Exec System Recovery 8.5

Like this post? Subscribe to my RSS feed and get loads more!