Microsoft KB Archive/104908

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:49, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.