Helping ordinary people create extraordinary websites!

Backup and Recovery Best Practices for Microsoft SQL Server 2005
Tuesday, 10th June 2008
Published by:


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


 5 Votes

Related White Papers:
» 5 Must-Ask Questions for SAN Storage Consolidation Success
» 4 Often Overlooked Benefits of Managed Video Services
» Best-in-Class Practices for Virtualizing Microsoft Applications
» Extending Virtualization in the Data Center with Application Infrastructure Virtualization
» Data Storage Outlook Summary Report
» Case Study: TV5MONDE Delivers Programming 24 Hours a Day