Re: Downgrade - 2005 Ent. Cluster -> 2005 Stand. Cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

Tom really meant to say:

SQL Server 2005 Standard Edition supports 2-node clustering...

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

"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:Ocezyia0GHA.4796@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server 2005 supports 2-node clustering. If you want more nodes (up to
8
total), you have to go to EE.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada

"Edwin vMierlo" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OzJRL7Z0GHA.4016@xxxxxxxxxxxxxxxxxxxxxxx
To my knowledge you need the Enterprise version of the OS as well as the
Enterprise version of the Application (SQL 2005 in this case) to cluster.

Therefore, if you want to cluster, you need Enterprise licensing.

If you want to downgrade due to the cost of Enterprise licensing, you
might
want look into other technologies for availability, such as database
mirroring or transaction log shipping and replications.

It is a matter of choice, clustering or logshipping or database mirroring
or
replication. Each solution comes at a cost, and each solution has its own
price tag.

rgds,
Edwin.


"David M." <David M.@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FB4FBB3A-3AF3-434B-A61E-A05A176C7F30@xxxxxxxxxxxxxxxx
I have an SQL Enterprise 2005 Cluster that should have been setup as 2005
Standard Cluster. Mainly for licensing and $$ reasons I need to convert
this. It is running on Win2K3 with just some small production databases
on
it (not heavy use). I am not using any special features for 2005
Enterprise
that would require that I leave that in place. What is the easiest way
to
downgrade this cluster? Will I have to rebuild this from scratch and
restore
the databases?

Thank you for any help you can provide.

David M.





.

Relevant Pages

  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Maybe the Records Are There After All
    ... Run DBCC UPDATEUSAGE to correct the row count display in Enterprise Mangler. ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Enterprise Manager and it gave me the sensation that ALL of the data had ...
    (microsoft.public.sqlserver.server)
  • Re: Cluster will not fail over.
    ... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... This worked bringing up the sql server in minimal mode. ... > Start SQL Server in single user mode with trace flag -T3608. ... > SQL from recovering anything except the master database. ... > You didn't mention whether you blew the cluster away or not or just ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)