SQL Server HA– Missing something? July 26th, 2011

Vinod Kumar

Recently have had the opportunity to work on Technical editing of a book for Satya Shyam (MVP – SQL Server) on “Microsoft SQL Server 2008 R2 Administration Cookbook”. The best part of the whole exercise was tons of learning and notes exchanged and I enjoyed every part of the close to 5-6 months engagement with the Editors and Satya. Finally, the book it out – link from the publishers site itself.

The HA/DR options are plenty and many a times it is difficult to choose one option over another. So let me pick your brain for what were those technology decisions based on the business needs you picked one option over another?

  1. Log Shipping
  2. Clustering
  3. Backup and Restore
  4. Database Mirroring – Async mode
  5. High Performance Mirroring
  6. Peer-To-Peer Replication
  7. Copy Database
  8. Shared Scalable Databases (Updated: thanks Robert)

Please leave a comment on –

  1. Why the decision? Map the business to technical limitation.
  2. What SQL Server HA/DR option was used?
  3. What do you wish was available in the option that you used which is currently missing? Typical example here, wish we could query the Database Mirror for reporting needs (agree there is snapshot, still it is a workaround).

Giveaway: Depending on the answers, will make available you an e-book given directly by the publisher. There are very limited copies only – so drop your  comments. Will announce winner on Friday based on the comments Smile. Cheers and pass the word around.

Tags: , , , , , ,

This entry was posted on Tuesday, July 26th, 2011 at 10:44 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “SQL Server HA– Missing something?”

  1. vinod a short cheat sheet of options could be very useful reference. thank you for putting it together. people have varied definitions of what qualifies for HA and what HA means. putting everything on the list initially make sense to me so here is one to consider Shared Databases

Leave a Reply