473,404 Members | 2,170 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

DB Backup to tape on Windows NT Server

Hi.

I want to do a db backup to tape. I looked thru the command reference
and it just says "to tape". I don't know how to reference the tape
drive on windows as it is not assigned a drive letter. Can someone
please give me the command? Should I be seeing the tape drive as a
drive letter?

Thanks,

Kush

Jun 28 '06 #1
3 2361
Ian
Kush wrote:
Hi.

I want to do a db backup to tape. I looked thru the command reference
and it just says "to tape". I don't know how to reference the tape
drive on windows as it is not assigned a drive letter. Can someone
please give me the command? Should I be seeing the tape drive as a
drive letter?


You refer to it using the Windows physical device name, i.e. \\.\TAPE0
or \\.\TAPE1. Make sure you use the INITIALIZE TAPE command, too.
Jun 28 '06 #2
Ian.

Thanks for your quick reply.

What exactly does the "initialize" command do? Does it wipe out the
existing data on the tape?

Thanks,

Kush
Ian wrote:
Kush wrote:
Hi.

I want to do a db backup to tape. I looked thru the command reference
and it just says "to tape". I don't know how to reference the tape
drive on windows as it is not assigned a drive letter. Can someone
please give me the command? Should I be seeing the tape drive as a
drive letter?


You refer to it using the Windows physical device name, i.e. \\.\TAPE0
or \\.\TAPE1. Make sure you use the INITIALIZE TAPE command, too.


Jun 28 '06 #3
Ian
Kush wrote:
Ian.

Thanks for your quick reply.

What exactly does the "initialize" command do? Does it wipe out the
existing data on the tape?


Actually I don't know exactly what it does. It probably just writes
some header information to the tape so that DB2 knows that it is a
"DB2" tape.
Jun 29 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mirko Slavko | last post by:
Hi, I have scheduled backup job on MS SQL server which appends full backup, verifies it and then it should eject tape. But upon finishing it says that job failed. I checked backup and it seems...
2
by: Chirath Fernando | last post by:
Hi We are running SQL 2000 Enterprice version with SP3a on a Dell Poweedge 5600 server running Advance Server. It has Tape drive PowerVault 110T (DLT VS80 Tape Drive) & uses DLT tapeIV tapes. A...
6
by: A.Y. Xu | last post by:
Environment: Win Server 2003 Standard Version, SQL Server 2000, HP DDS3 Tape(local). Backup procedure: 1. open SQL Server Enterprise Manager 2. find the database i want to backup 3. right click...
6
by: tgru | last post by:
Hello, Can anyone tell me how to backup read-only databases? I want to backup the secondary databases in my log shipping pairs. Thanks, TGru *** Sent via Developersdex...
3
by: rcamarda | last post by:
I do weekly full backups of my SQL databases via a scheduled T-SQL job. I noticed that I have some static databases that dont normally change, so I dont want to back it up if it has not changed,...
9
by: Stanley Sinclair | last post by:
I just brought a new small server online. It has two disks in RAID1 (mirrored) for the operating system and logs and DB2 DBMS. DB2 data on a separate RAID 5EE array on four disks. (IBM ServeRAID...
8
by: nek | last post by:
Greetings, Has anyone got the latest progress on this? It hit me this time on W2K running DB2 V8.1.5. It returned the following warning: D:\Temp>db2 backup db sample to \\localhost\tape0...
1
by: wolphie | last post by:
The IT shop I work in installed MS-SQL Server last week for the sole purpose of converting a large MS-SQL Server database to a format that Informix (our main database engine) can read. MSSQL...
3
by: dcruncher4 | last post by:
It is possible that we may be asked to restore a production tape, say 3 yrs later. We would prefer redirect restore for that. I am documenting a process to do a redirect restore. We take...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.