Microsoft KB Archive/104908

FIX: SQL for NT Admin Backup Event

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

4.20

WINDOWS

BUG# NT: 9257 (4.2)

= SYMPTOMS =

When a 16-bit SQL Administrator version 4.2.11 for Windows NT attempts to add a scheduled backup event to occur at a start time of a single digit (like 7:00 AM, 8:00 AM, or 8:15 PM), cause of the following:

  You may get the error: The start time entered for the scheduled backup event is out of range.   The minute part of the start time might be changed to a different value, for example, start time of 7:00 might be changed to 7:02 or 7:22. 

= WORKAROUND =

To work around the above error of start time being out of range, enter the single digit time with a zero in the prefix. For example, instead of entering 8:15, enter start time of 08:15.

Another work around is to use the 32-bit version of SQL Administrator on Windows NT which does not show this behavior.

= STATUS =

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for Windows NT. This problem was corrected in SQL Server version 4.21. For more information, contact your primary support provider.

Additional reference words: 4.20 win16 sqltools Windows NT KBCategory: kbtool KBSubCategory: Administration SSrvWinNT

=
================================================================

Copyright Microsoft Corporation 1994.