September 21, 2009 at 4:26 pm
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
September 21, 2009 at 7:48 pm
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
September 22, 2009 at 12:10 am
September 22, 2009 at 12:32 am
chk2009 (9/21/2009)
We have one prod server and are planning setup high avialabily. We are into 99.99% prod environmentSQL 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]
September 22, 2009 at 2:58 am
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