On Tuesday, September 21, I'll be at the Sarasota SQL Server Users Group to present Paging DR Availability, You're Wanted in the Recovery Room. This is my first time at the Sarasota UG and I'm excited to meet new people, share something useful, and sneak in a word about the upcoming SQLRally. Here's what I'll be covering:
The meeting starts at 6 PM and is being held at the Community Foundation of Sarasota County, 2635 Fruitville Rd. Sarasota, FL 34237
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.
I hope to see you there!