FIX: NT SQL Admin May Be Erratic when Reading Tape Directory
  
PSS ID Number: Q117516
Article last modified on 10-31-1994
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
BUG# NT: 9768 (4.2)
 
SYMPTOMS
========
 
When using the Windows NT version of SQL Administrator to scan the
directory of a tape and one or more query timeouts occur, SQL Administrator
may GP fault, return unreadable information, or fail to return at all.
 
When reading the tape directory using the Load Database selection under
Manage Databases, the following situations may occur if SQL Administrator
is configured to ignore timeouts:
 
  - If no timeouts occur, operations work normally.
 
  - If a timeout occurs, the data returned to the screen is garbled. For
    example, the "Volume Number" may be blank, and the "Volume Label" may
    be "Q0001". No information is returned in the list of dumps. If the
    command is run again without exiting the screen, SQL Admin may end
    with an error message that the instruction at "0x00XXXXXX"
    referenced memory at "0x00XXXXXX". The memory could not be "read".
 
  - If the Tape Directory command is chosen, then the list box is
    simply filled with meaningless information.
 
CAUSE
=====
 
The problem is caused by timeouts occurring while waiting for the results
from SQL Monitor.
 
WORKAROUND
==========
 
Upgrade to version 4.21. Or, increase the "System Functions" timeout to a
value greater than the time it takes to scan the tape.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in SQL Server version 4.2.
This problem was corrected in SQL Server version 4.21. For more
information, please contact your primary support provider.
 
Additional reference words: 4.20 SQL Admin tape hang trap Windows NT
KBCategory: kbtool kberrmsg
KBSubCategory: SSrvWinNT SSrvBkup SSrvSQL_Admin
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
