Showing posts with label server1. Show all posts
Showing posts with label server1. Show all posts

Friday, March 30, 2012

Renaming a SQL Cluster

Can anyone tell me if it's possible to rename a cluster?
Fro example, we have an Active/Passive cluster made up of two servers.
'Server1' and 'Server2' which make up the cluster 'Cluster1' is it
possible to rename this to 'Cluster2' without affecting the servers that
make it up?
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Yes, you can rename the cluster. You can't rename SQL Instances though.
Start Cluster Administrator from the Cluster Group Controlling node - use a
"." as the cluster name.
Take the Cluster Group Offline.
Double click on the Network Name resource and change the parameters
information.
Bring the Cluster Group Online.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Dave" <Anonymous@.devdex.com> wrote in message
news:O$m1e2McFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me if it's possible to rename a cluster?
> Fro example, we have an Active/Passive cluster made up of two servers.
> 'Server1' and 'Server2' which make up the cluster 'Cluster1' is it
> possible to rename this to 'Cluster2' without affecting the servers that
> make it up?
> Thanks
>
>
> *** Sent via Developersdex http://www.codecomments.com ***

Wednesday, March 28, 2012

Renaming a Server

Hello

I am wondering if this is able to be done and what implications there would
be with SQL Server.

Server1 name: Production Currently running Windows NT and SQL 7
instance name is Production
Server2 name: Test Currently running Windows 2000 and
SQL 2000, instance name is Test - default installation

Bring the Server1 offline and rename Server 2 with the name of Production.
Do we have to change the instance name in SQL now on Server 2? If so can we
do this? I didn't think you could change a instance name and had to
reinstall SQL.

Another Question:

Can you have 2 instances of SQL with the same name but reside on different
servers?

Thanks
SherHi

[cut]
> Another Question:
> Can you have 2 instances of SQL with the same name but reside on different
> servers?
Yes, you can have instance1 on server1 and server2 - you always connect to
any of them specifying full name: server1/instance1 or server2/instance1.

Tomik|||snewell2003 via SQLMonster.com (forum@.SQLMonster.com) writes:
> I am wondering if this is able to be done and what implications there
> would be with SQL Server.
> Server1 name: Production Currently running Windows NT and SQL 7
> instance name is Production
> Server2 name: Test Currently running Windows 2000
> and SQL 2000, instance name is Test - default installation

Is that Test\Test or just Test? Production is obviously not
Production\Prodction as there are no named instances on SQL 7.

> Bring the Server1 offline and rename Server 2 with the name of
> Production. Do we have to change the instance name in SQL now on Server
> 2? If so can we do this? I didn't think you could change a instance
> name and had to reinstall SQL.

If SQL 2000 is a default instance, this should not be difficult. There
is one thing you need to once you have moved:

EXEC sp_dropserver Test
go
EXEC sp_addserver, Production, LOCAL

And the reboot afterthis. Else @.@.servername will be wrong.

> Can you have 2 instances of SQL with the same name but reside on different
> servers?

As long as the machines are not connected to each other. if they are on
the same network, I would not recommend it.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp