Re: Active / passive in SQL 7

The package is called "Failover Clustering" and is a built-in feature of SQL
2000 Enterprise Edition and SQL 2005 Enterprise and Standard Editions.
Windows 2000/2003 Enterprise Edition is also required.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"David Sherman" <dshermin@xxxxxxxxxxxxx> wrote in message
news:nvtmu11ik9jpnf2i7nlrhf6ppq0f64nqbd@xxxxxxxxxx
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: materialized view rewrite
    ... "query rewrite" I beleive is only available in the Enterprise Edition. ... We've got the enterprise edition on linux. ... SQL> col banner format a100 ... TNS for Linux: Version 10.2.0.1.0 - Production ...
    (comp.databases.oracle.server)
  • Re: Benchmark for different edition SQL 2000
    ... > My concern is how to prevent the SQL server that increase the memory usage continuously? ... > Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 Standard upgrade to Enterprise
    ... *databases* on the *SQL build* number. ... I believe it is possible to restore the backup of a system database taken on ... on to an Enterprise Edition. ... > We are upgrading from SQL Server 2000 Standard to ...
    (microsoft.public.sqlserver.setup)
  • Re: Active / passive in SQL 7
    ... Failover clustering has been supported since SQL Server 7.0 so it is ... How does one use Failover Clustering withe Windows 2000 Advanced ... 2000 Enterprise Edition and SQL 2005 Enterprise and Standard Editions. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2000-2005 Clustering
    ... Since SQL Clustering runs on MSCS you have to have a cluster-capable OS. ... That means Enterprise Edition for Windows Server 2003 or Advanced Server for ... > Thanks......Supported O/S have to be Enterprise edition ...
    (microsoft.public.sqlserver.setup)