SQL Server Performance Forum – Threads Archive
the order to restart sql cluster serverhi, guys: want to ask you a question which might be quite simple for you. I need to restart cluster server ( windows 2003 & sql 2000 sp3, active/passive two nodes), I am wondering what’s the order to restart it.
Is it to
1. shutdown passive node
2. stop sql server on activenode
3. shutdown active node
4. start up active node
5.start up passive node For I am new and don’t have such experience. Please share your experience and any help will be appreciated
can anyone give me a clue?
Well, when I have to restart both A/P cluster nodes.. I do like this way..
Restart Passive Node (Name: MacP).
Once passive (MacP) node boot up, I use Cluster Admin and move SQL services from active (MacA) to Passive (MacP) Node.
Confirm SQL is running fine (on MacP), then I do restart previously Active (MacA) node.
This practice require very less downtime for application.. Its just like restart of SQL services.. It also test cluster services during moving SQL service; whether working fine or having troubles.
Note: Using this way you get change in Active node to Passive and vice-versa.
Deepak Kumar –An eye for an eye and everyone shall be blind
Yes no need to have both nodes offline at the same time. Follow procedure that Deepak mentions.
thanks deepakontheweb & argyle. your infomation is quite useful.
I am still wondering if there is any difference between restart two nodes as Deepakontheweb mentioned and shutdown.
For there is a problem with sql server memoery leak, I want to restart totally to fresh the cluster system. thanks
There is no difference, one is faster that is all. You sure you have a memory leak? SQL Server will take all availabe memory on the system if it think it needs it. You can cap the max memory setting to leave 200-300 for the OS.