How to script/automate a sql cluster failover
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
How to script/automate a sql cluster failover

 
Post new topic   Reply to topic    Windows Server Forum Index -> Clustering
Author Message
louis n
Guest
Posted: Mon Oct 24, 2005 8:50 pm    Post subject: How to script/automate a sql cluster failover Reply with quote
Is it possible to write a script or some utility that will let me
schedule a failover?

I've been asked to automate and schedule -- failover of a two node sql
cluster. e.g. fail over to node 2, restart node1, fail back to node 1,
restart node2.

The sql cluster(s) are windows 2000 advanced server running MSSQL 2000.

Thanks in Advance
Back to top
John Toner [MVP]
Guest
Posted: Tue Oct 25, 2005 8:50 pm    Post subject: Re: How to script/automate a sql cluster failover Reply with quote
shutdown.exe could certainly be used as well to script a reboot of a node.

Regards,
John

"louis n" <louisducnguyen@gmail.com> wrote in message
news:1130183210.262988.192720@g47g2000cwa.googlegroups.com...
Quote:
Is it possible to write a script or some utility that will let me
schedule a failover?

I've been asked to automate and schedule -- failover of a two node sql
cluster. e.g. fail over to node 2, restart node1, fail back to node 1,
restart node2.

The sql cluster(s) are windows 2000 advanced server running MSSQL 2000.

Thanks in Advance
Back to top
Chuck Timon [MSFT]
Guest
Posted: Tue Oct 25, 2005 8:50 pm    Post subject: Re: How to script/automate a sql cluster failover Reply with quote
You can use the cluster.exe commands in a batch file and then use the
scheuler service to run them.

--
Chuck Timon, Jr.
Microsoft Corporation
CCS Beta Engineer
This posting is provided "AS IS" with no
warranties, and confers no rights.
"louis n" <louisducnguyen@gmail.com> wrote in message
news:1130183210.262988.192720@g47g2000cwa.googlegroups.com...
Quote:
Is it possible to write a script or some utility that will let me
schedule a failover?

I've been asked to automate and schedule -- failover of a two node sql
cluster. e.g. fail over to node 2, restart node1, fail back to node 1,
restart node2.

The sql cluster(s) are windows 2000 advanced server running MSSQL 2000.

Thanks in Advance
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Clustering All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB