Desktop

Ask something
Discussion Locked

SQL Server Backup Fails

0 helpful
5 replies

by sharad sreedharan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

URGENT Help Required

I have a COMPAQ Proliant 1600 box with 4/8 GB DAT drive running MS SQL 7.0

Until few days back, I only had one user database to be backed up. I added one more and when I try to append both backups onto a single tape, I getthe following errors:

1. Source:Kernel
Message: BackupTapeFile::SkipFileMark::SetTapePosition failure on backup device '\\. \Tape0'. Operating system error 23(Data error (cyclic redundancy check))

2. Source:Kernel
Message:
BackupTapeFile::ConfigureTape:GetTapeParameters(GET_TAPE_DRIVE_INFORMATION) failure on backup device '\\. \Tape0.' Operating system error 23(Data error (cyclic redundancy check)).

Currently I'm running the risk of not backing up the databases on a regular basis.
Help appreciated.

5 replies

by richard lane

Can you let us have a little more info? What OS (NT/2000)? What are you using to backup? (standard MS Backup, AT command scheduler, proprietary backup software supplied with the tape drive)? What size are the DBs you're tring to backup - I foundthat with a 4/8 Gb drive, using the MS Backup and the AT command scheduler rather than the prop. software, the compression wouldn't work, and got similar errors once the data size exceeded 4Gb.

Waiting your response.

Richard

by richard lane

Sorry, I am going to have to pass this on to someone with more experience of the SQL Server backup. Hope you find the answer.

lots of luck

Richard

by sharad sreedharan

Sorry Richard!!

More eager to solve the problem, I guess I forgot mention the details. Thanks for your information.

OS is Win NT 4.0, I'm using native SQL server interface for backup. The DB's are less than 1 GB

I've similar setup of NT servers with SQL Server 7.0 working in quite a few other installations without any problems. But, with two locations I'm having this problem, I'm not sure why it is so?? Basically, appended backup does not work using SQL Server 7.0 backup interface.

Thanks in advance for your help.

Regards,

Sharad

This discussion is closed to new replies.