On Tuesday, June 15, I'm presenting Paging DR Availability, You're Wanted in the Recovery Room at the Orlando SQL Server User's Group. We're meeting from 6 - 8:30 PM at the SQL Share offices, 225 S Westmonte Dr. Suite 2010 in Altamonte Springs. The presentation portion of the meeting will be broadcast via Live Meeting (attend here) starting sometime around 7 PM. Presentation details follow below. Hope to see you there!
Paging DR Availability, You're Wanted in the Recovery Room
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Some, such as log shipping, replication, clustering, and mirroring ship with SQL Server. Others, such as disk level replication and virtualization rely on third party products. Most business owners (and many DBA’s) lump disaster recovery (DR) and high availability (HA) together and while they do share some pieces, they call for different strategies. There are lots of options. Do you pick one or more than one of these options, and based on what? When does it make sense to move from SQL mirroring to SAN mirroring? Does it ever make sense to do log shipping and replication on the same database? Even if you haven’t yet mastered all of these options, it’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, and reasons for using each of them.