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