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… Read More

I’ve got two webcasts this month that I’m doing with Quest:Pain of the Week: Mission Critical SQL: High Availability – From Amateur to Aficionado in Less Than an Hour October 148 AM Pacific/11 AM Eastern/4 PM UK/5 PM Central EuropeClick here for more information and to register and a followupPain of the Week: Mission Critical SQL: High Availability Part 2October 218 AM Pacific/11 AM Eastern/4 PM UK/5 PM Central EuropeClick… Read More

A customer of mine contacted me this week about a problem they were having. They have a two-node failover cluster on Windows Server 2008 R2 with an instance of SQL Server 2008 with SQL Server 2008 SP1. They installed SQL Server’s program files to another drive – not the main system drive (C). They then configured log shipping. Everything worked fine until they were testing failover. When the instance was failed over to… Read More