Re: Active / passive in SQL 7

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks for the infomation.

Is there a way to write a script that monitors the active node and
when it dies (1) notifies the DBA of the failure and (2) starts the
passive node. or (3) is there a package that will do this?

thanks


On Thu, 9 Feb 2006 10:29:31 -0600, "Michael Hotek"
<mike@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

The first thing you have to check is whether the hardware is even supported
for SQL Server 2005. Secondly, unless Enterprise Edition is installed, you
aren't going to get SQL Server 2005 into a failover cluster.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.


"David Sherman" <dshermin@xxxxxxxxxxxxx> wrote in message
news:e7jmu1hk54lfb1i126lrs35dknv2dtk12r@xxxxxxxxxx
A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to
upgrade to SQL 2005. I want to know how he can do the below with SQL
7?

His message:


That feature, available with the SQL Server7 Enterprise, would allow
my passive node to startup the database without any DBA involvement.
Right now my cluster simply fails over, but SQL7 does not
automatically activate on the passive node once the shared disk is
available. This is because the passive node only checks for the
presence of the disk drive at bootup. Hence, it does not start the
service when the disk is available after a fail-over.

At the end of the day, I would be running the same database in the
same manner, with no licensing implications because I have not changed
the availability or seat count; I would merely have the second node
fire up after it detects the availability of the shared disk where the
program and data files reside.

Thanks


.

Relevant Pages

  • Re: Active / passive in SQL 7
    ... Secondly, unless Enterprise Edition is installed, you ... aren't going to get SQL Server 2005 into a failover cluster. ... my passive node to startup the database without any DBA involvement. ... fire up after it detects the availability of the shared disk where the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Clustering with 2 active nodes and 1 passive node
    ... Mike Epprecht, Microsoft SQL Server MVP ... >> If you have 2 nodes, one sits around waiting for a failover. ... >>> we are being asked to setup a 2 active node, 1 passive node environment. ...
    (microsoft.public.sqlserver.clustering)
  • Re: sql transactions per second
    ... good sense of app server and web server hit counts and capacity needs, ... SQL Server to the max, and what their SQL transaction per second count is. ... before all other hardware constrains growth). ... Be prepared to hire a really good DBA who knows how ...
    (microsoft.public.sqlserver.server)
  • Re: Among available RDBMS. When to use ...
    ... "When these new options are not set, SQL Server 2005 default database ... Given that Oracle's multiversioning has long outperformed SQL Server, ... is it possible to keep DBA? ... I would think an ISV needs a DBA more, ...
    (comp.databases)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... now the SQL injection attacks and/or crash the service attacks need ... to be address separately (no real DBA options here). ... The proper way to secure this though isn't in SQL Server per se. ... Microsoft's putting a lot of effort into security. ...
    (microsoft.public.sqlserver.security)