TechWeb Digital Library

Backup and Recovery Best Practices for Microsoft SQL Server2005

Source: HP
Date: April 2008
Type: White Paper
Rating: (1)

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

By leveraging the recommendations and best practices, administrators can shorten backup windows and efficiently load the server, thereby reducing cost and maximizing the use of hardware and personnel resources.


Click here to download now

View all content from this source

Not what you’re looking for? Search again
Go Advanced »
Email Alert

Receive an email alert whenever new content is added to the Hardware section of the TechWeb Digital Library

More Hardware Resources

Data Center Survival Guide
It's a jungle in there. Today's data center is highly complex and hard to manage. That drives up costs, power and cooling requirements and provisioning time,...

Learn how innovative thinking can benefit your data center
In this white paper from The Bathwick Group, courtesy of IBM, you’ll learn the role of innovation in the data center.

More On Hardware