Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/101848

From BetaArchive Wiki

BUG: Dumping to a Compaq SystemPro DAT Tape - Stops Responding

PSS ID Number: Q101848 Article last modified on 07-23-1993

4.20a OS/2 buglist4.2a

Problem ID: Bug# 1706

SYMPTOMS

When dumping to a 1.3/2.0 GB tape from a SQL Server version 4.2a running on a Compaq SystemPro, the SQL Server may stop responding. Existing connections are frozen or will time out. Often, the only recourse is to power off the computer, because OS/2 will refuse to shut down, saying that not all processes could be terminated. When dumping to a 5 GB tape drive, the tape dump may stop responding with no messages, but SQL Server continues to run and accept new connections. However, you may not be able to shut down SQL Server or OS/2. This only happens with Sytos version 1.35 tape drivers and SQL Server version 4.2a.

WORKAROUND

Using the Sytos Plus software to perform any tape operation properly initializes the tape interface, and allows SQL Server to use the tape until the next time SQL Server is shut down.

Example

  1. Restart SQL Server.
  2. Start Sytos Plus.
  3. Insert any tape into the drive.
  4. From the Utilities menu, choose Media Preparation.
  5. Choose View Volume Info. You should now be able to dump the tape from SQL Server.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2a. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional reference words: 4.20a 4.2a freeze backup dump hang