We help IT Professionals succeed at work.
Get Started

Disk Staging Tape Consolidation fails for SQL Backup.

jokes54321 asked
Last Modified: 2008-07-25
We run Arcserve r12. We backup multiple file servers and a SQL servers using GFS.

We use a Primary server with disk staging and the staging policy is enabled to consolidate when migrating the data to tape. The tape drive is a Dell 16 tape LTO3 autoloader.

What is happening is the Daily Full SQL backup isn't being consolidated to the same tape as the file system backups. So every day this 200MB database backup is consuming an entire 400/800GB tape.

I've contacted CA Support and the first day they looked, they said what's happening for for the Weekly Full backup was normal. He said the next day, our incremental backup, it would consolidate fine. The following day it didn't consolidate so CA looked again and told me to check the Append option where I specified the consolidation policy. I told him the manual said that option would consolidate all the dailies onto a single tape instead of using a new tape for each day. He said in a GFS setup it wouldn't, so we tried it. The manual was correct and all my dailies started appending on Monday's tape.

Is anyone successfully getting SQL and file system backups to consolidate to a single tape?

Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE