Describe HA and DR strategy and win

Dear Readers,

I am very please to made an announcement about the contest.  As you aware that I have wrote a book on SQL Server 2008 High Availability which was published on 24th January 2008 2011 by Packt Publication. Now you have a chance to win a subscription worth £150 of digital library at Packt Publication and a Paper book of SQL Server 2008 HA, here is the information.

Who this book is for?
This book is written for the System Administrator, experienced SQL Developers who want to learn about the topic – SQL Server High Availability, Aspiring DBAs. That means, this book is having a step-by-step instructions, pre-requisite with plenty snapshots to get you through the installation of SQL Server High Availability options like Cluster, Replications ( Snapshot, Transactional, Peer-2-Pee and Merge), Log Shipping and Database Mirroring.

I have tried to include external reference for further study on that particular topic if you wish to read some advance information, I have also include few common issues and how to resolve them for every topic i.e. How to troubleshoot common issues for Clustering, Replication, Log Shipping and Database Mirroring.

Here is the detailed index for every chapter of this book at - http://www.sql-server-citation.com/2011/01/sql-server-2008-high-availability-book.html

Where to buy?
One can purchase my book SQL Server 2008 High Availability from Packt Publication in Paper and eBook format at https://www.packtpub.com/microsoft-sql-server-2008-high-availability/book or one can purchase this from Amazon at http://www.amazon.com/Microsoft-Server-2008-High-Availability/dp/1849681228/ref=sr_1_1?ie=UTF8&s=books&qid=1299390127&sr=8-1

Contest Information:

Describe the best HA and DR solution you have designed or worked upon, especially in case of physically dispersed location, and the reason why?

The best answer will win a  subscription of digital library worth £150 at Packt Library for 1 year and 2nd best answer will win Paper book of SQL Server 2008 HA.

The best answer will be judged by me and Satya Shyam K Jayanty (whom I admired as Guru.), we will announced the winner by 25th April 2011.

1. Their will be two winners - 1 Subscription and 1 Paper book of SQL Server 2008 HA
2. The contest will remain open until 5th of April 2011
3. The Packt Pub Subscription will be free for 1 year

By mistake I have mentioned that my book was published on 24th January 2008, I did not noticed it until Ashish Sharma draw my attention, I have corrected it now. Thank you Ashish :)

What are you waiting for, start participating and be a lucky winner!!!

-- Hemantgiri S. Goswami | www.sql-server-citation.com



  1. Where should i send my entry..

  2. you can post it in the comment area itself.

    Hemantgiri S. Goswami

  3. LinkedIn Groups

    Group: SQLDBA
    Discussion:Describe the best HA & DR designed you work and get a chance to win free PacktLib Subscription for year refer http://tinyurl.com/6addr69

    The architecture I use is Microsoft Geo-Cluster which runs across dark fiber to a secondary site about 25 miles from the primary. The hardware is all server class equipment with hot swappable and redundant components. The Geo-cluster uses redundant EMC DMX SANs using SDRF-CE to provide simultaneous data replication. If the cluster fails over then storage and server fail as well.
    All applications use DNS to point to the servers - also is redundant. Applications are mandated to be cluster aware and account for failover.
    Databases are backed up to a virtual tape library offsite. Backups are tested both full restore and log restore once a week. The operating system and other software are patched in a QA environment then in production within 30 days of patch release. All software required to be at a current support level from the vendor.
    SQL is configured for the minimum services and a conservative approach using tuning measures that will foster stability.
    SQL servers are on a separate network, firewalled and monitored for security threats, denial of service threats etc. There are some other nuances but in a nutshell that it.

    Posted by Dave Thomas


I appreciate your time, thanks for posting your comment. I will review and reply to your comment as soon as I can.

Thank you