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:
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!
PingBack from http://geeklectures.info/2007/12/31/on-the-seventh-day-of-christmas-an-it-pro-sent-to-me/