FIX: Loading Tape Dump from SQL Admin May Fail
  
PSS ID Number: Q112097
Article last modified on 10-31-1994
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
  - Microsoft SQL Server version 4.2
----------------------------------------------------------------------
 
BUG# 9677 (4.2)
 
SYMPTOMS
========
 
Attempting to load a tape dump into a SQL Server for Windows NT SQL Server
may result in the error message:
 
   Backup/Restore has ended in error
 
However, the restore seems to run as expected. The tape is unloaded and you
are prompted to remove the tape. The rest of the restore process,
initialization and recovery, seems to run the normal amount of time. Then,
when you would expect the message box to appear indicating that the load
was complete, you will receive an error message indicating the load failed.
 
This problem does not occur with SQL Server for OS/2.
 
CAUSE
=====
 
The SQL Monitor program is not handling the tape restore correctly under
certain conditions. The conditions usually, but not always, require a large
database being loaded and the SQL Administrator System Timeout parameter
and the SQL Monitor /sqltimeout parameter to be small values that are
multiples of one another.
 
WORKAROUND
==========
 
Load the tape dumps using the LOAD DATABASE command directly from ISQL,
ISQL/w, or the query window of any other tool. In some cases, changing the
SQL Administrator System Functions Timeout to a larger value (using SQL
Administrator Configuration option), changing the SQL Monitor timeout value
(using /sqltimeout= option) to a larger value, and making sure the two are
not multiples of each other sometimes prevents the problem from occurring.
 
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, contact your primary support provider.
 
Additional reference words: 4.20 Windows NT
KBCategory: kbtool
KBSubcategory: SSrvWinNT SSrvSQL_Admin
 
=============================================================================
 
Copyright Microsoft Corporation 1994.
