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


The information in this article applies to:

  • Microsoft SQL Server 6.5
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
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbfix kbHardware kbinterop KB161125
©2003 Microsoft Corporation. All rights reserved.