Qualify for your FREE Issues!

Backup and Recovery Best Practices for Microsoft SQL Server 2005

Description: 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

Publisher: Hewlett Packard Corporation