Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-09-21 : 18:25:03
|
| We have one prod server and are planning setup high avialabily. We are into 99.99% prod environmentSQL Server 2005 std version 9.00.1399Please advice for which below feature is best?LogshippingReplicationDBmirroringclustering |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-09-21 : 19:18:34
|
| It depends.Each of those technologies is good for different particular needs, and selecting the right one for you will require a lot more analysis than a single question to a forum. Your demand for 99.99% up-time gives you less than 2 hours per week of possible down-time, so you're probably going to need a big budget to pull this off. But that's one of the questions to ask yourself...what is your budget? What happens if you don't meet the 99.99% availability? If this is a new environment, why are you deploying SQL Server 2005 when SQL Server 2008 has already been out for nearly a year? What are your disaster recovery requirements? Do you need remote data centers that can keep the databases alive and available if an earthquake hits your primary datacenter?And then there's the question of who is going to manage all of this, because with that type of a requirement, you'd better have some skilled SQL Server DBAs on-staff who should be involved in making this decision with you.--------------------------------------------Brand yourself at EmeraldCityDomains.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-09-21 : 22:29:30
|
| If 99.99% is your uptime requirement, then you should use Enterprise edition. The online index rebuilds is a huge benefit of using that edition.We use all 4 technologies in our 99.999% highly available environments. They are all used for different things, so there's not one that we can recommend based upon the information that you have provided.Along with 99.999% high availability of the database, you must ensure the server hardware, network hardware (firewall, switches, ...) are all highly available by making sure you have backup devices. The more 9s you require, the more expensive the solution.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
|
|
|
|
|
High Availability