Is there a special step by step procedure to follow when rebooting a Windows 2003 Cluster server (Active/Passive) with SQL 2000 cluster server running and the databases stored a SAN device?
Not really. If you are doing a manual reboot of the cluster, reboot the passive node. When it comes back up fail over to it, then reboot the second node.
Denny
--Anything is possible. All it takes is a little research. (Me)
I'm not sure what you mean by the MS Windows failover. But if you mean the virtual name on the network, then yes the cluster admin controls that as well.
Denny
--Anything is possible. All it takes is a little research. (Me)
We are running Windows 2003 Ent Ed with the OS clustered and then SQL DB's clustered over 2 nodes active/passive.
The quorum disk and disk groups are all on the SAN device?
With my limited knowledge which is poor I am trying to work out if this is separate or not. When you build a server you set-up cluster in MS windows 2003 and then install SQL with clustering?
This is something very new to me as unfortunately our cluster tech is no longer with us. So I am wondering if there is a different process for a SQL cluster or OS cluster set-up or if they are controlled together through cluster admin? If you failover does it failover everything including the DB's etc, what is the effect on users, should you backup first? That sort of thing.
Say we had a server without SQL installed is the reboot process the same? Not sure if I am being clear.
In the cluster admin window you should see the SQL Server, the Agent, the disks, etc. They should all be tied together. If you fail over any one resource (sql, agent, disks, etc) they will all fail over in the correct order.
You shouldn't need to do a backup specifically because of the reboot, however you should be doing regular backups.
Denny
--Anything is possible. All it takes is a little research. (Me)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.