High availability

  • We have one prod server and are planning setup high avialabily. We are into 99.99% prod environment

    SQL Server 2005 std version 9.00.1399

    Please advice for which below feature is best?

    Logshipping

    Replication

    DBmirroring

    clustering

  • That is an awfully general question. Which one is better completely depends upon what you are trying to accomplish, distance between the servers, data being transfered, and numerous other factors.

    Probably worth you starting here and reading the articles and notes from Microsoft on what the difference between each of them are and then come back with some more specific questions.

    http://msdn.microsoft.com/en-us/library/ms190202.aspx

    Fraggle

  • From my personal Experience, I will say 'clustering'. But as stated above it depends upon several factors as to which method one should use for High Availability.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • chk2009 (9/21/2009)


    We have one prod server and are planning setup high avialabily. We are into 99.99% prod environment

    SQL Server 2005 std version 9.00.1399

    Please advice for which below feature is best?

    Logshipping

    Replication

    DBmirroring

    clustering

    http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

    Ok, first things first, you are running the RTM version, so basically it hasnt had any service packs applied to it or fixes. secondly you are running a standard edition, most high availability options are better implemented using the enterprise edition. depending on your requirements.

    As suggested before, it is quite a big subject. Clustering will always be most peoples favourite, as it is easier in some ways to implement. without knowing more detailed requirement, it is hard. replication is not really a high availability tool, not compared to mirroring or any of the others.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • We have one prod server and are planning setup high avialabily.

    If you only have one physical server, then you can rule out high availability.

    For any form of high availability, you are going to need at least 2 servers.

    Clustering gives you protection against server failure... the others you mention protect you against data loss in some way or other.

    What sort of high availability do you need... hardware redundancy or protection against data loss or both.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply