Infrastructure Management White Papers
Backup and Recovery Best Practices for SQL Server 2005, Including HP Data Protector
Overview
With databases regarded as mission critical in most companies, the ability to back up Microsoft SQL Server 2005 data when required and within the specified backup window is vital. To help you choose from 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 you can understand the options and the limitations of implementing backup and recovery in an enterprise environment using Linear Tape-Open (LTO) tape, disk-to-disk, and virtual tape devices. Additionally, the paper discusses:
- Backup and recovery recommendations for the integration of Data Protector Software and Microsoft SQL Server 2005
- The impact on database performance and throughput for each of the backup methodologies
- General recommendations for selecting which backup and recovery method to use
- 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 (HP) | File Format | |
|---|---|---|---|
| Date Published | January 2008 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 0 out of 1 users found this white paper useful
White Paper RSSThe Benefits for Growing and Mid-Sized Businesses of a Having One Integrated Business Management Software Suite
DownloadOvercoming the barriers of stand-alone business applications is a major challenge to growth for companies worldwide. Learn how an expanding organization can better gain control of its business operations and...
Aberdeen Group: On-Demand Mid-Market CRM: Front-to-Back Office Integration a Clear Differentiator
This Aberdeen Executive Analyst Whitepaper discusses the importance of front-to-back integration when evaluating CRM vendors.
Creating Cost and Energy Efficiency through Outsourcing Hosting Solutions
The White Paper looks at the efficiencies of outsourcing web and online infrastructure in an increasingly volatile and environmentally aware society. Specifically the white paper looks at the benefits...
IT Optimisation: the low fat approach to IT
A typical business spends 80% of its IT budget - managing and operating its IT infrastructure, rather than investing in it.This paper looks at ways you can optimise your IT...
Identity and Security Management and Strong Information Technology Goverance
A total identity and access management (IAM) – driven goverance, risk and compliance (GRC) solution should ensure foolproof and accurate measurements of policies and practises across the enterprise. This IDC...
