October 25, 2005 at 5:22 pm
Hello!
I have inherited 2 node active/passive SQL Server cluster. I have
noticed that SQL Server service is running on active node only. I was
wondering if this is normal behavior. In case of failover, will SQL Server
service start automatically on passive node? What will happen if new
databases created on while service on active node is running and failover
occurs? I guess, since system specific information is stored in system
tables rather than on shared SAN (in our case) drives, I am not sure how will it be replicated to passive node in case of failover.
I would appreciate if somebody can point me to the articles on this
subject.
Thanks,
Igor
October 26, 2005 at 6:45 am
Hi, just a quick note to say that this is totally normal, the active/passive setup indicates that only one of the nodes is active at any one time.
As for whether it will fail over properly, the only way you're going to know for sure is to actually failover (or move group). Obviously this will chop the connections to the DB and you will probably want to do this out of office hours.
October 27, 2005 at 11:44 am
A good place to start is Books On Line topic "Failover Clustering Architecture". Then search on "cluster" or "failover" and you'll be reading for awhile 🙂
Linda
October 27, 2005 at 11:59 am
Thanks, Mike!
October 27, 2005 at 12:00 pm
Thanks a lot, Linda!
October 27, 2005 at 12:00 pm
Thanks a lot, Linda!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply