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

x
?
Solved

Need advice on restore method

Posted on 2008-10-08
4
Medium Priority
?
225 Views
Last Modified: 2013-12-01
We recently had some data corruption that is forcing me to pull backup from tape.  I am running into a snag and it is probably just my lack of knowledge that is getting in the way.  Backup run like this...

Starting on Friday evening 1700, our full backups of 10 servers kick off to backup-to-disk folders on my backup server.  These full backups take the entire weekend to complete.  Early Monday morning our Incremental backups begin and continue every morning thru Friday.  On Friday we do a full backup to tape of all the data on the backup server including all the backup-to-dick folders from the week.  So far after about 5 hours, I have been unable to restore data from a tape to a place recognized by Backup Exec as a valid resource with our over existing data in backup-to-disk folders.  I think I may need to create separate devices, media sets and backup-to-disk folder specifically for restore but not really sure if that is the correct way to go.

If this make any since to anyone and you think you might have a solution please help.

thanks.
0
Comment
Question by:CityofKerrville
  • 2
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
honmapog earned 2000 total points
ID: 22671422
As you meanwhile found out, backing up Bkf files to tape is a very bad idea if you want to be able to restore the individual files that were backed up in the B2D jobs.
It makes restoring a nightmare.

Check my answers in http://www.experts-exchange.com/Storage/Backup_Restore/Q_23059539.html and http://www.experts-exchange.com/Storage/Backup_Restore/Backup_Exec/Q_23099170.html to get the contents of the bkf file restored. I believe that's what you want to achieve.
0
 

Author Comment

by:CityofKerrville
ID: 22671692
"As you meanwhile found out, backing up Bkf files to tape is a very bad idea"....DOH!!

I removed that the existing media from the database and am not in the process of cataloging the backup set I want to restore from.  Time to think of something different for my backup solution.
0
 
LVL 28

Expert Comment

by:honmapog
ID: 22672191
If you want to write B2D backups to tape, you should use what is called a "duplicate job".
Although your current scenario may not be very good for duplicate jobs. They really only run fine when you do them right after the B2D job finishes.
0
 

Author Closing Comment

by:CityofKerrville
ID: 31504225
Thanks for the help.  Hopefully you are available when I start re-thinking my backup procedures.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

580 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