Can I scheule an automated failover to happen nightly?

I have an interesting problem. We just installed a 2 node active/passive
windows 2003 enterprise cluster. We are also running SQL 2000 enterprise
server on it.

We have a 3rd party application that runs SQL that seems to have a memory
leak. The 3rd party product is not cluster aware and I have had to create a
generic service for their service in order to make it failover. However,
their service currently has a significant memory leak that eats all 4 gig of
ram in the server.

While this company is trying to resolve their memory I need to be able to
find a temporary fix in the meantime so the servers don't failover during the
day. I am trying to accompolish 1 of 2 things:

1) Setup an automated schedule to take this generic service offline at say
3:00 a.m. and then bring it back online at 3:05 a.m. each night to free up
the memory.

or

2) Schedule the entire resource group to failover to the passive node at
say 3:00 a.m.

I know that with a regular server environment I could just schedule a
service to restart whenever I wanted using the AT command, however with a
clustered environment I need to use cluser administrator to take the resource
offline, then back online.

Any ideas?

Ian Davies
ian.davies@xxxxxxxxxxxxxxxxxxxxxx
.

Relevant Pages

  • RE: server problems
    ... This newsgroup only focuses on SBS technical issues. ... >Thread-Topic: server problems ... >> web proxy service or SQL Server will normally use large memory. ...
    (microsoft.public.windows.server.sbs)
  • Re: Allocated Memory alerts
    ... If you do not encounter any real server performance issue, ... the high memory usage is expected. ... The Health monitor is running on the SBS server. ... A memory allocation threshold is configured on the particular monitored ...
    (microsoft.public.windows.server.sbs)
  • Re: FTS Performance in SQL 2005
    ... I don't think you have left enough memory for the OS and MSSearch. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • [Full-Disclosure] eServ Memory Leak Enables Denial of Service Attacks
    ... eServ Memory Leak Enables Denial of Service Attacks ... eServ is a hybrid Web server, FTP server, mail server (POP3, SMTP, ...
    (Full-Disclosure)
  • [VulnWatch] eServ Memory Leak Enables Denial of Service Attacks
    ... eServ Memory Leak Enables Denial of Service Attacks ... eServ is a hybrid Web server, FTP server, mail server (POP3, SMTP, ...
    (Full-Disclosure)