Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-10-25
6
Medium Priority
?
595 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:magotici
  • 3
  • 3
6 Comments
 
LVL 23

Accepted Solution

by:
bhanukir7 earned 2000 total points
ID: 37033975
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
 

Author Comment

by:magotici
ID: 37034262
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
 
LVL 23

Expert Comment

by:bhanukir7
ID: 37034364
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:magotici
ID: 37037564
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
 
LVL 23

Expert Comment

by:bhanukir7
ID: 37037615
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
 

Author Closing Comment

by:magotici
ID: 37037640
Thank you!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question