Seven 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!