Solved

Backup to Disk then to Tape

Posted on 2003-11-25
4
399 Views
Last Modified: 2012-05-04
Hi. We've implemented a new SQL 2000 Server with Veritas Backup Exec 9. We've got additional disks so we can do a backup to disk, so if a restore is required then it can be done quickly from disk, then have a backup to tape.

I'm just after the correct procedure for setting this up. I could do a backup to disk, then another backup to tape, but is there a correct method for setting this up (possibly a backup to disk, then spool that backup to tape?)
0
Comment
Question by:paulo123
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:chicagoan
ID: 9817488
It's a pretty common method as you can script the disk dump and schelud the tape backup sometime inbetween dile dumps without the SQL agent software - and restores from the dump files are about as fast as you're going to get.
  Ideally the dump should go to another local drive unless you're on a SAN to minimize the hit on the disk channel.
If you're backing up over the network during production it's nice to have a second nic on a private network dedicated to backup as well.
0
 

Author Comment

by:paulo123
ID: 9818052
Thanks for that, chicagoan. Can you expand a little on what you mean by 'script the dump'? I've only worked on bog-standard tape backups before. The tape drive and backup drive are local to the server being backed up. Thanks again.
0
 
LVL 18

Accepted Solution

by:
chicagoan earned 125 total points
ID: 9818089
In  Enterprise Manager, expand the SQL Server to display your databases.
 Right-click on the database and select All Tasks > Backup Database
0
 

Author Comment

by:paulo123
ID: 9858710
Great! Thanks for that.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I have written before on the benefits of using a Boot media other than your HDD when it has become infected.   The article I wrote about creating a bootable CD/DVD/USB (http://e-e.com/A_2343.html) was mainly concerned with building a UBCD4Win on CD …
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now