SQL Server 2008 R2 cluster setup fails on mount points

(Update from Monday morning, the workaround shown below works for me) Another day, another set up problem (sigh) I was installing a second SQL 2008 R2 instance on a new cluster today. The first one had gone well without incident but the second one had a crucial change in that it used mount points. It… Continue reading SQL Server 2008 R2 cluster setup fails on mount points

Step by Step procedure for rolling upgrades to database mirroring for SQL Server 2008

Here’s something I was up to during the week. It’s a fairly mundane task, but despite that one which is very important, both to the client I was doing it for, and for most people generally who run this type of configuration. The databases I was working with were part of a true 24×7 configuration where any… Continue reading Step by Step procedure for rolling upgrades to database mirroring for SQL Server 2008