Microsoft KB Archive/112097

FIX: Loading Tape Dump from SQL Admin May Fail

PSS ID Number: Q112097 Article last modified on 10-31-1994

4.20

WINDOWS

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.