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 |
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2010-09-16 : 19:33:05
|
Hi all, I'm going to be taking care of a running system but haven't done this since around 2002 or so, and am pretty rusted. Anyone know any good articles I can read to come up to speed in case of a failover?Thanks,Jake. |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Jake Shelton
Yak Posting Veteran
74 Posts |
Posted - 2010-09-16 : 19:46:12
|
Hi Tara,Presumably clustering as I've read some scant docu mentioning the heartbeat, but that's as specific as it got. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-09-16 : 19:50:38
|
I don't have any good articles handy. Clustering is a complex topic. Is there anyone there that can get you up to speed? We hired a consultant to train us and setup our first cluster. This was many years ago. Is a budget available to help you get started?In the case of a failover, SQL Server should come online on the other node and everything be fine (assuming the applications can handle it). We have monitoring in place to notify us when a failover occurs, so that we can look at the system and figure out what happened.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-17 : 07:23:43
|
start with this white paperhttp://www.microsoft.com/downloads/en/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en |
|
|
|
|
|