November 2010

November 9, 2010

UPDATE – Combining Clustering and Log Shipping Bug

I’m out here at PASS this week and was in the CAT area. Cindy Gross (who works for MS and blogs here) hooked me up with someone who let me know that what I found back in May (where if you changed your path for install, things like log shipping wouldn’t work after failover) has been fixed. This is GREAT news.

The fix can be found in SQL Server 2008 SP1 CU10 and it didn’t get finished in time for SP2, but it will be in SQL Server 2008 SP2 CU1.

So how do you deal with the problem if you’ve already deployed?
Well, installing the CU won’t fix the issue. You’d have to slipstream the CU into your 2008 install, remove the node, and re-add the node to SQL Server. I am not saying evict the node in Failover CLuster Manager – just run the normal remove process for SQL Server.

How do you ensure that all new deployments do not have this issue?
Slipstream the CU before running Setup.

November 1, 2010

New Whitepaper Published – Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications

Hello all! I hope to see some of you next week at PASS. But in advance of that, I wanted to let you know that a whitepaper I co-authored this past summer was just published. It is entitled “Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications”. The title may be a bit misleading, because it’s something EVERYONE can use if you do any kind of development as well as patching of your SQL Server applications, databases, and instances.

In this whitepaper we cover:

The different kinds of SQL Server updates and how they differ
Other updates that affect SQL Server
How to understand versioning in SQL Server
GDR Branching – the first time this has been formally covered anywhere!
How to perform ongoing testing
Developing a supportability roadmap

Like I said, forget the fact for a moment that it references ISVs – this is a paper that we wanted to get out because it really will benefit a lot of you.

The whitepaper can be found as part of this blog post: http://blogs.technet.com/b/sql_server_isv/archive/2010/10/20/hot-fixes-and-cus-and-service-packs-oh-my.aspx

Enjoy!

Popular Posts

Categories