?
Solved

Backup to Disk then to Tape

Posted on 2003-11-25
4
Medium Priority
?
408 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

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!
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
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…

765 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