June 30, 2009 at 12:52 pm
Hi,
When we take a SQL Server resource (of a SQL Instance) on a cluster offline, does it stop the SQL Server Service on the node that owns that SQL Server Instance?
Could anyone help me what actually happens when we take the SQL resource offline on a cluster?
Thank You,
Yours,
SQL Buddy.
June 30, 2009 at 1:24 pm
I am 95% sure that when SQL is taken offline that it stops the service on whatever node has it..
CEWII
June 30, 2009 at 2:08 pm
When you take a resource group in a cluster offline, all resources in that group are taken offline also. They are not failed over, which means the services are stopped or the fileshares are no longer accessible.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2009 at 2:46 pm
Hi Elliott,
Thanks a lot for your reply.
Yours
SQL Buddy.
June 30, 2009 at 2:49 pm
Hi Jeffrey,
Thank you very much for your reply. You cleared all my doubts. That's a fantastic answer. I really appreciate that.
Yours
SQL Buddy
June 30, 2009 at 2:56 pm
You are welcome.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2009 at 9:17 pm
Yes, you are very welcome..
I Love Clustering, once you get the concepts down and you actually get good hardware..
CEWII
July 2, 2009 at 12:16 pm
What happens when you failover? Is it again a SQL restart?
Let's say for eg., one of my job is running in a clustered instance and a failover happens...what will happen to my job? Will it fail or succeed?
July 2, 2009 at 12:26 pm
SUBRAHMANYA HEDGE (7/2/2009)
What happens when you failover? Is it again a SQL restart?Let's say for eg., one of my job is running in a clustered instance and a failover happens...what will happen to my job? Will it fail or succeed?
It fails, just as if it was a nonclustered server that crashes.
July 6, 2009 at 4:44 am
The reason that the 'fail' occurs is that all of the cluster resources on the original/'active' server must be shut down on the physical server hosting those resources so that they can then be restarted on the new server/host. This shutdown/restart cycle is logically similar to rebooting a server - although it shouldn't take as long, and occurs in an automated/planned fashion. SQL Server transactions and jobs will of course suffer the outage while the failover occurs as the instance (as noted previously) does go down.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply