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...

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

  • Comments 1
  • Likes

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: ,


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment