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