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
Solved

Backup to Disk then to Tape

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dell Server drives 9 67
RAID Configuration 18 62
P2000 SAN SAS - RAID5 or RAID50 10 41
Netapp snapshot 9 32
Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
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…

839 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