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

• Microsoft SQL Server version 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 : kbhw kbinterop SSrvAdmin SSrvErr_Log SSrvGen kbbug6.50
Version : 6.5
Platform : WINDOWS
Issue type : kbbug