Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

On the Seventh Day of Christmas an IT Pro sent to me…

Seven SANs a Spinning

7 SANs a Spinning

If you have your SQL Server databases on a SAN, then please admire my cartoon and move along.

However if you don’t you might wish to know that mirroring in SQL Server 2008 is a little bit less painless than in 2005.  The traffic is compressed, so it will take up less bandwidth and the transfer is asynchronous in that a SQL server 2008 mirror works from a hardened (written to disk) copy, and new log records a first hardened. I found this post from SSQA.NET and of course there’s books on-line on MSDN.

Finally you can use forced failover to upgrade your SQL Server 2005 mirror to 2008:

  • Upgrade the mirror form 2005 – 2008

  • Force a failover to get the 2008 mirror to now be the principal

  • Upgrade the new mirror from 2005 – 2008

  • upgrade the witness et viola!

A bit of testing would of course be a good idea before you do this in production, maybe using virtual machines or instance to check all is well in your environment!

Technorati Tags: ,