ARCserve 15: restore MS SQL DB from the staging area instead of tape

Hi,
I intend to do a staged backup to disk then migrate it to tape. Is it possible to do a DB restore using the backups existing on the disk staging area after the migration to the tape was executed? This would save some time as opposed of doing it from multiple tapes (the tapes could be in the storage area).
Thank you.
magoticiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bhanukir7Commented:
hi magotici,

as long as the staged backups are not purged from the staging device, you should be still able to perform a restore from the disk staging area.

Ideally, when you try to perform a restore of any backup that was done using staging (aka source>>disk>>tape) the restore would search first from the staging device and if it is not able to find the sessions it will ask to mount the tapes.

one thing you would certainly need to consider is what kind of capacity do you have on the staging device and what kind of policies you have in place, i.e. purge sessions after migrating to tape or retain the backups on staging device for 10-15 days.

hope this helps, if you have any further questions post your questions so that me or other experts can help

regards
bhanu
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
magoticiAuthor Commented:
What happens if the migration tape is in use by another job? Is the D2D2T job going to wait for that job to finish and then do the migration?
0
bhanukir7Commented:
unless your D2D2T job is set to append to tape, every time you setup a migration job, it normally would format a available tape (unless that is protected by retention policies) otherwise the migration would fail and will create a makeup job and run at a different time.

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

magoticiAuthor Commented:
If it is set to append, will it wait for the ongoing job, then will append at the end of the tape or will fail and create a makeup job. If it creates a makeup job do I have to set the time it runs?
0
bhanukir7Commented:
you can set the max time the job should wait for media, default is 60 or 90 minutes. The makeup job will be scheduled to run automatically after 4-5 hrs.
0
magoticiAuthor Commented:
Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.