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 2005 Forums
 High Availability (2005)
 Shipping in 2K5

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

Posted - 2010-09-16 : 19:34:10
A failover of what? Are you using clustering? Mirroring? ...?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-09-17 : 07:23:43
start with this white paper

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en
Go to Top of Page
   

- Advertisement -