Ezine

This article can also be found in the Premium Editorial Download "Storage magazine: Comparing the top data backup packages."

Download it now to read this article plus other related content.


Using disk and tape for incremental backups

The cost of using both disk and tape for backups is not only cost-effective, but provides a higher level of availability and business continuance
  PERFORMANCE
FACTORS
COST
FACTORS
BUSINESS CONTINUANCE
FACTORS
Tape Need to multiplex to keep tapes streaming, which slows restore process

Need to de-multiplex tapes using slow tape-to-tape copy process

Frequent full backups are required for performance and data integrity reasons
Requires additional hardware and software for tape sharing

Tape devices require tape loading and often require extensive maintenance
Tape-to-tape copies are time-consuming,

Requires Free Membership to View

which results in organizations not keeping adequate off-site copies

Media management issues and tape failures often result in data loss and/or significantly exposed risk

Tape libraries aren't normally highly available and are subject to complete failures
Disk Files recoveries require no tape swapping, load time or fast-forward

Disk-to-tape copies are fast and efficient

Restores from incrementals don't increase the recovery time (and there is no decrease in data integrity)
Easy to share among clients performing concurrent backups simultaneously

Lower management and maintenance, reduced media costs, less media handling and more efficient use of rack space
Off-site copies of data can easily be sent remotely via Ethernet

Disk backups are RAID protected

Disk backups are highly available

Looking at the numbers
It's generally accepted that disk storage has a lower TCO vs. tape-based storage due to its ease of use and lower management overhead. Disk is also multifunctional compared to single-use tape. However, the inconvenience of having to manage and move tapes is greatly offset by the lower cost of the media. In our example (50GB daily for incrementals x four incrementals/week x four week retention + 250GB weekly for cumulative incremental x three weeks/month x three month retention=3TB) disk storage requirements will increase by 3TB. Consequently, there's a balance between what data is backed up to disk and what data is sent to tape.

The cost of using both disk and tape for backups is not only cost-effective, but provides a higher level of availability and business continuance (see "Using disk and tape for incremental backups," this page). Specific to database environments, another trade-off is the management of database transaction logs. Normally, full database backups truncate log files after they're copied to tape. Any logs that have already committed their transactions to the database are either archived or deleted. As indicated in Rotation schedule with incremental backups", full backups are performed at the end of every month, allowing the database log files to remain on disk. As a result, database log files will be monitored and managed.

Today, most organizations perform multiple backups during the day. Generally, this is accomplished through snapshot copies generated from the file system (Network Appliance's WAFL, Veritas VxFS), volume manager and utilities (Veritas VxVM, Sun StorEdge Instant Image) or through storage arrays (Sun/HDS ShadowImage, HP Business Copy VA). Either way, the data is readily available and safely stored on disk. Most organizations will then make a tape copy from the end-of-day snapshot--or better yet, replicate the snapshot to an off-site facility where tape copies are created.

Generating incremental snapshots during the day provides an extra level of data availability and is highly recommended. These point-in-time copies, however, don't replace the need of using third-party backup software. Commercial backup software provides proper auditing, management and configuration controls as well as extensive recoverability options for data protection requirements.

Mixing disk and tape for backups provides better flexibility, improved performance and enhanced business continuance. Disk backups are based on open standards and seamlessly integrate into an existing storage network infrastructure. The costs associated with using disk for backup purposes needs to be balanced against service level agreements and budgetary constraints. It's best for organizations to invest in extra disk capacity when budgeting, designing or building a SAN. Investing in additional capacity during a SAN deployment offers a lower cost of entry for the opportunity of incorporating disk storage into backup processes. In the long run, both disk and tape offer a cost-effective, highly available data protection solution.

This was first published in March 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: