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.
