Only once every four years thank goodness!

I never cease to be amazed by what I discover within IT, mostly these days I'm more disappointed than anything else, I'm not a lover of the let's bash Microsoft about security patches or we should all use Linux / Open source as in the latter I'm sure if the most popular o/s was linux it would be full of exploits.

However I was faintly amused to discover there's a bug in SQL 2008 which doesn't let it run on Feb 29th. Common guys how can this be, I've just wasted some considerable time trying to understand why my SQL won't run, it's on a stand alone laptop not connected to the internet - shock horror -  you're just not going to do your reputation much good with this and on top of the will there be a service pack 3 for sql 2005 , let's hope it's not like sp2 if it is!

You'd just expect better !

Published 29 February 2008 19:57 by GrumpyOldDBA

Comments

# re: Only once every four years thank goodness!

02 March 2008 13:59 by Uri Dimant

Hello GrumpyOldDBA  (sorry  do not know what  your name is)

This comment comes out from MS guy

A bug has been discovered in the CTPs of SQL Server 2008 related to leap

year.  Although there is no known impact on SQL Server 2005 or prior

versions at this time, we are continuing research on all versions. The

result of this bug is that SQL Server 2008 services will not start during

the 24 hours of Feb 29 GMT.

Action: Do NOT stop or restart any SQL Server 2008 services during those 24

hours.

We are communicating this information to you early in our investigation, and

we will issue an update within 90 minutes.

These are the details we have at this time:

. We are currently testing workarounds and a longer term code fix.

. Modifying the system time is not a work-around, may cause side-effects,

and is strongly discouraged.

. At this time, there is no known customer impact on SQL Server 2005 or

prior versions

. There is no known danger of data corruption or security exposure

. This is on all editions of SQL Server 2008

. This is on all operating systems