THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search
Home Blogs Forums Roller Downloads   Opml View as RSS news feed in XML

Peter DeBetta's SQL Programming Blog

Peter DeBetta's blog about programming in SQL Server 2008, 2005, etc. using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.

SQL Server 2008 Leap Year Issue

Microsoft reported:

"We have recently discovered an issue with SQL Server 2008 CTPs that result in SQL Server 2008 not starting or installing on Feb 29 GMT only. We recommend that you do not run, install or upgrade this CTP on Feb 29 GMT to minimize any impact in your environment. You can install starting on March 1 GMT...."


Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Published Friday, February 29, 2008 11:42 AM by Peter DeBetta

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

SQL Server Blog by Jason Massie on SQL Server 2005 and SQL Server 2008. said:

February 29, 2008 1:15 PM
 

James Luetkehoelter said:

Thanks! I very nearly got caught by this as I'm loading it on a new laptop!

February 29, 2008 1:17 PM
 

Denis Ruckebusch said:

Is there any additional information available regarding the nature of the problem? I am very surprised to see this is a startup/setup issue.

The first thing that came to my mind when I heard there was a leap year problem with SQL Server 2008 was that there was an issue with some of the datetime data types. I didn't even think that setup or startup could be affected by bad leap year calculations.

Also the way the issue is described it looks like it won't be a concern anymore once we roll into March 1st.

I'd love to see exactly what the issue is.

February 29, 2008 1:19 PM
 

Peter DeBetta said:

Couldn't tell you exectly what is going on, only that something is.

I haven't heard or seen any issue with the date and time types.

On a good note, earlier today I started a Virtual PC with CTP6 on it that was previously saved yesterday. Since the service was, in essence, already running, I didn't experience any issues.

February 29, 2008 1:26 PM
 

jerryhung said:

Mnn, not a good first impression for SQL Server 2008

please let it not be SQL 2005 SP2 mess repeat =P

February 29, 2008 3:24 PM
 

Denis Gobo said:

Of course I couldn't wait to see this for myself on my virtual pc  :-(

February 29, 2008 3:50 PM
 

Peter DeBetta said:

It is a CTP and not RTM. And this is why it is available for public use (AKA the ultimate QA).

February 29, 2008 3:54 PM
 

El año bisiesto y Microsoft at Blog de Pablo Vernocchi said:

PingBack from http://www.itpros.com.ar/blog/el-ao-bisiesto-y-microsoft

March 3, 2008 2:33 PM
 

Geoff said:

I know the leap day has passed. But did anyone try changing the computer's date and then changing it back.

March 3, 2008 5:29 PM
 

jimsz said:

I haven't pulled almost 24hrs straight in a while and I have told my wife I'll try to keep them

March 4, 2008 12:31 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About Peter DeBetta

Peter DeBetta is an independent consultant specializing in design, development, implementation, and deployment of Microsoft SQL Server, Microsoft SharePoint Server, and .NET solutions. Peter writes courseware, articles, and books – most notably the title Introducing SQL Server 2005 for Developers from Microsoft Press. Peter speaks at conferences around the world, including TechEd, SQL PASS Community Summit, DevTeach, SQL Connections, DevWeek, and VSLive!

Peter is a Microsoft MVP for SQL Server, an MCP, President of the North Texas SQL Server User Group, and a member of PASS.

When Peter isn’t working, you can find him singing and playing guitar (click here to hear an original song by Peter), taking pictures, or simply enjoying life with his wife, son, and new daughter.

This Blog

Syndication

News


My new book is coming soon:

Introducing SQL Server 2008


©2006-2008 SQLblog.comTM
Brought to you by Peter DeBetta & Adam Machanic
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement