High availability

Question

High availability

HBK_4700

SSCrazy Eights

Points: 8932
More actions
September 21, 2009 at 4:26 pm

#141900

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

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

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

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 1

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

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

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]

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

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]

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 4

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.