Active / passive in SQL 7

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
    ... How old is the equipment running SQL 7? ... MVP - Windows Server - Clustering ... 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: Different sp:s on cluster nodes
    ... SQL requires single-user access ... during the SP or Hotfix to update system objects within the database. ... > I thinking of configuring a 2 node, single instance cluster. ... Upgrade the passive node, switch passive node to ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 cluster
    ... The passive node also has 8 GB of RAM, 150 GB of SAN disk, and has 4 local ... test instances of SQL 2005, ... mapped to clustered disk resources and are specific to each SQL instance. ... - On the passive mode, in the above configuration, can the local instances ...
    (microsoft.public.sqlserver.clustering)
  • Re: replace failed node without downtime? (sp1 question)
    ... will it leave the active node online while it patches the passive node ... My understanding of your issue is: After adding a new node in SQL 2005 ... we have following two ways to apply SQL Sp1 for this SQL ... Add registry Need_SP_Key on the passive node and install SQL ...
    (microsoft.public.sqlserver.clustering)
  • RE: Active/Passive failover-Failed?
    ... When I attach to SQLSERVER in sql enterprise mgr, it attaches, however, If I ... -Should the CLUSTER SERVICE be AUToMATIC startup on the passive node? ... From your statement above, you said that only the virtual server name is available, not SQL IP addr. ...
    (microsoft.public.sqlserver.clustering)