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
Did you find this white paper useful?
Related white papers
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...
IDC Executive Brief: The Rising Concerns Over Endpoint Security
Today's IT environment is increasingly vulnerable to threats and attacks, both from within and without. The most vulnerable node in the enterprise network is the endpoint. This IDC executive brief...
The CIO profession: driving innovation and competitive advantage
Learn what CIOs are thinking in this report on the 2007 CIO Leadership Survey, conducted by the Center for CIO Leadership.
Drive Enterprise Innovation with IT Simplication
Today's globally competitive business climate demands that organisations reduce complexity to ensure the reliable delivery of products and services to customers, and to better adapt to fast-changing business needs.This white paper...
Protecting key assets (security)
Key infrastructure elements must be secured against outages, damage and sabotage. Siemens offers comprehensive solutions from healthcare and power generation to water supply, transportation, and industrial production, to telecommunications.
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...
Ensuring Data Protection for Growing Business
Small and midsize businesses have become increasingly reliant on IT. In this paper, we look at how SMBs often progress through the IT adoption cycle, and some of the operational...
