Solved

Backup to Disk then to Tape

Posted on 2003-11-25
4
401 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hubic: real life experience? 5 63
Onpremise file server with cloud synch 1 98
HP VSA on ESXi Best Practice 3 81
Home lab datacenter 9 50
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
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…

770 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