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/104908

From BetaArchive Wiki

FIX: SQL for NT Admin Backup Event

PSS ID Number: Q104908 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: 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:

  1. You may get the error:

    The start time entered for the scheduled backup event is out of range.

  2. 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.