Backup on Tape - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Backup on Tape

Author

Topic

rksingh024
Yak Posting Veteran

56 Posts

Posted - 2002-08-28 : 09:28:50

Hi,

While taking a backup on tape I got following error:
Operations on device '\\.\Tape0' exceeded retry count.
Backup process terminated abnormally.

I am using this sql:
BACKUP DATABASE mydb TO TAPE='//./Tape0'
WITH NOINIT, STATS, NAME='mydb backup'

Don't understand what is wrong. Please help!

Ramesh

chadmat
The Chadinator

1974 Posts

Posted - 2002-08-28 : 13:16:45

http://support.microsoft.com/?scid=kb;en-us;Q280793

-Chad

rksingh024
Yak Posting Veteran

56 Posts

Posted - 2002-08-29 : 02:11:17

Hi Chad,

Thanks for reply.

But my sql server 2000 runs on the WINNT.
Is there some specific tape required for backup sql databases.

Is it necessary to stop the SQL-server for taking back-up on Tape.

Ramesh

Edited by - rksingh024 on 08/29/2002 03:50:41

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2002-08-29 : 13:18:10

Hi Ramesh
This can happen if you have previous NT backup on the same tape.
You might try a blank tape or format the tape before using it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources