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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 High Availability

Author  Topic 

goblyn27
Starting Member

39 Posts

Posted - 2003-08-08 : 19:59:59
Hi Guys,

I am a programmer for a web developement company, and as the lone MS guy in a linux house, it kinda falls on my shoulders to know EVERYTHING related to Microsoft products whether it is programming, DBA Work, Sysadmin work, or Tech Support.

Anyway, the subject of high availability of our MS web and database servers keeps coming up and I want to be prepared when I am put on the spot. I found a good number of resources on the Microsoft site but they were extremely dry reading, and with my schedule I usually can fit in a page or two before I get pulled away to do something else, so most of it goes in one eye and out the other.

Can anyone recommend any resources, book or websites, that deal with this topic that they found to be useful and interesting? Or at the very least not deathly boring and difficult to read without my eyes crossing?

Muchas Gracias. Any help will be appreciated.

"DuuuDe!! I suck!"

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2003-08-09 : 16:20:15
Well,

For SQL Server take a look on www.sql-server-performance.com Clustring section.

On MS Site there for SQL Server, in http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/confeat/sqlha/SQLHALP.asp

regards,


Sérgio Monteiro
Trust in no Oracle
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-08-11 : 12:02:44
I've had really good experience with Active-Active clustering. It's not easy to setup and it's expensive. Once it's up and running, it's a beautiful thing! Be sure that all the hardware you have is supported in a MS Cluster.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-11 : 12:36:11
I would suggest bringing in a consultant to do the High Availability work. It is not simple stuff. When we implemented this kind of solution, we had DBAs, server administrators, network administrators, and the vendor all working together to get it done. It took weeks of work. Since you do not have some of these people at your work, I would suggest finding someone such as a consultant who has a lot of that experience.

Tara
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2003-08-11 : 15:13:06
I totally agree with Tara. It took quite a while to get it setup and running initally. You might also want to consider a "cluster in a box" type solution from HP/Compaq. I don't work for them, but they have a pretty nice solution that is fairly easy to setup. Be sure to get support contracts for any clustered servers. You will almost HAVE to call support at some point.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -