Knowledge Base

FIX: DUMP or LOAD with Tape May Fail on Windows NT 3.51

Article ID: 161125

Article Last Modified on 10/3/2003

APPLIES TO

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q161125

BUG #: 16346 (6.5)

SYMPTOMS

A SQL Server dump or load with a tape may fail on a computer running Windows NT 3.51 and some SCSI controllers.

WORKAROUND

To work around this problem, do any of the following:

Try to put the tape drive on a different SCSI adapter.
Upgrade to Windows NT 4.0.
Dump to disk files instead of tape files.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

MORE INFORMATION

The following are some of the possible errors that can be seen in the SQL Server errorlog:

Error : 3201
Can't open dump device '<device name>', device error or device off line.
Please consult the SQL Server error log for more details.

kernel Unnamed tape \\.\tape0 mounted on tape drive \\.\tape0
kernel tprhdrs: failed to seek Tape Mark, operating system error:
1101 (A tape access reached a filemark.)
kernel tbsreadhdr: Tape rejected
kernel tprvol: read returned 1104 (no more data is on the tape.)
reading volume header

Additional query words: 6.50 blocksize backup restore

Keywords: kbbug kbfix kbinterop kbhardware KB161125

Microsoft KB Archive/161125

Contents