renaming drive letter

I want to add a new drive to replace an existing drive used by SQL
server(cluster installation).
My plan is to
1. stop sql related services.
2. copy sql db files to new drive...
3. Rename new drive with existing drive letter.
4. start sql.
My question is - will the change of drive letter work normally for cluster
installations or do i need to take any special care?If the drive letter is the same, the original files and directories are put
back, and the account running SQL Server has permissions to the files then
SQL won't detect any difference and be fine. However,
the cluster service may be a different story.
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?|||Hi
Changing a drive letter in a cluster becomes a lot more complicated as the
cluster services depend on it.
You have to between steps 2 and 3, remove the dependency in cluster manager,
then re-name the letter, establish the dependencies in cluster manager and
then start SQL Server.
It is best to take SQL Server and Agent offline, and then reboot each node
to make sure the groups and resources fail over correctly. Then bring SQL
Server online again.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?

renaming drive letter

I want to add a new drive to replace an existing drive used by SQL
server(cluster installation).
My plan is to
1. stop sql related services.
2. copy sql db files to new drive...
3. Rename new drive with existing drive letter.
4. start sql.
My question is - will the change of drive letter work normally for cluster
installations or do i need to take any special care?
If the drive letter is the same, the original files and directories are put
back, and the account running SQL Server has permissions to the files then
SQL won't detect any difference and be fine. However,
the cluster service may be a different story.
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?
|||Hi
Changing a drive letter in a cluster becomes a lot more complicated as the
cluster services depend on it.
You have to between steps 2 and 3, remove the dependency in cluster manager,
then re-name the letter, establish the dependencies in cluster manager and
then start SQL Server.
It is best to take SQL Server and Agent offline, and then reboot each node
to make sure the groups and resources fail over correctly. Then bring SQL
Server online again.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?
sql

renaming drive letter

I want to add a new drive to replace an existing drive used by SQL
server(cluster installation).
My plan is to
1. stop sql related services.
2. copy sql db files to new drive...
3. Rename new drive with existing drive letter.
4. start sql.
My question is - will the change of drive letter work normally for cluster
installations or do i need to take any special care?If the drive letter is the same, the original files and directories are put
back, and the account running SQL Server has permissions to the files then
SQL won't detect any difference and be fine. However,
the cluster service may be a different story.
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?|||Hi
Changing a drive letter in a cluster becomes a lot more complicated as the
cluster services depend on it.
You have to between steps 2 and 3, remove the dependency in cluster manager,
then re-name the letter, establish the dependencies in cluster manager and
then start SQL Server.
It is best to take SQL Server and Agent offline, and then reboot each node
to make sure the groups and resources fail over correctly. Then bring SQL
Server online again.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Bharath" <Bharath@.discussions.microsoft.com> wrote in message
news:DD1F651A-F5D2-49B0-A220-3BD6343E815D@.microsoft.com...
>I want to add a new drive to replace an existing drive used by SQL
> server(cluster installation).
> My plan is to
> 1. stop sql related services.
> 2. copy sql db files to new drive...
> 3. Rename new drive with existing drive letter.
> 4. start sql.
> My question is - will the change of drive letter work normally for cluster
> installations or do i need to take any special care?

renaming domain

We have a small site where we want to rename the domain and bring it into
our domain.
current names are as
domainx.local -holds SQL server cluster
domainx.net -main domain
we want to bring domainx.local into the domainx.net AD.
will will rename and migrate. Are there any tools for SQL2005?
we were planning on using the microsoft domain rename tool and ADMT3.
Any other issues with SQL?
Regards
CCSQL itself doesn't really care what domain it is in, as long as all of the
resources and servers it has to access are still accessible the way they
were before. The only thing you will have to update is the windows service
accounts if any of them are from AD and not the local machine. Will it be
renamed or are you moving to a new domain while the old domain remains up
for a short period of time? If the latter I would recommend setting up a
trust and switching the accounts, or understanding that you might have blips
in uptime/availability.
"Ned" <Cal@.obded.org> wrote in message
news:%231UNGh2ZIHA.2000@.TK2MSFTNGP05.phx.gbl...
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>|||Hi
I assume that the machine names for the SQL Servers are not changing?
If you have granted logins to domain accounts or groups then you may need to
change them see http://support.microsoft.com/kb/298897/
John
"Ned" wrote:
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
>

Renaming Cluster Nodes

Realise it is a common question and have searched through the group:
I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
renamed (Nodes, cluster name)
Is there any way to bypass re-installing SQL 2000 after this has been
completed?
(Various non microsoft sites point towards using sp_dropserver and
sp_addserver or updating the syservers table)
eg http://blog.opsan.com/archive/2005/05/10/465.aspx
http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
Thanks.
why you need rename nodes?
you can change virtual server name but microsoft not recommend this.
do NOT update system tables manually.
if you rename sql server (sp_dropserver and sp_addserver), cluster will not
check sql status and servis will be mark as failure.
best solution: install new sql
Aleksandar Grbic
MCDBA, Senior Database Administrator
"RichardT" wrote:

> Realise it is a common question and have searched through the group:
> I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
> renamed (Nodes, cluster name)
> Is there any way to bypass re-installing SQL 2000 after this has been
> completed?
> (Various non microsoft sites point towards using sp_dropserver and
> sp_addserver or updating the syservers table)
> eg http://blog.opsan.com/archive/2005/05/10/465.aspx
> http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
> Thanks.
|||"RichardT" <RichardT@.discussions.microsoft.com> wrote in message
news:7DE1DC20-FF62-4B1B-BE0A-6151F11D06F9@.microsoft.com...
> Realise it is a common question and have searched through the group:
> I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be
> renamed (Nodes, cluster name)
> Is there any way to bypass re-installing SQL 2000 after this has been
> completed?
> (Various non microsoft sites point towards using sp_dropserver and
> sp_addserver or updating the syservers table)
> eg http://blog.opsan.com/archive/2005/05/10/465.aspx
> http://msdn2.microsoft.com/en-us/library/aa197071(SQL.80).aspx
Well, I would start with going back to basics and doing a risk assessment
associated with the change and mitigation strategies. Risk, everything
possible going wrong. Mitigating that risk: Don't make the change as it is
completely unnecessary.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
NYC starting Feb 19th
London starting March 6th

Renaming cluster

I am looking for some help with a SQL Upgrade that we are doing. We have an
older server running SQL 2000. We also have a MSCS cluster that we've built
which is running SQL 2005. We want to get all the databases on the SQL 2005
cluster and retire the SQL 2000 server.
Is there any way to rename the cluster? It seems to me that the easiest way
would be to restore the databases from 2000 to 2005, take down the 2000
machine, rename the 2005 cluster to have the same name as the old SQL 2000
server and we're done.
The other option is to bring down the 2000 server, but keep the 2005 machine
with the new name - problem is there's a lot of old code that has the
connection strings hardcoded. It was suggested that we could do a DNS
pointer to resolve the old server name to the new name, but that didn't seem
to work with all of the apps that we've tested...
Any suggestions? I haven't been able to find much advice on how to do a
2000 to 2005 upgrade when you're also switching servers. Thanks for your
time.
Why bother renaming? Create a DNS SRV record repointing the old name to the
new server/instance.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Morgan" <Morgan@.discussions.microsoft.com> wrote in message
news:66673D99-7035-491D-87EA-A10DE2A89FEB@.microsoft.com...
>I am looking for some help with a SQL Upgrade that we are doing. We have
>an
> older server running SQL 2000. We also have a MSCS cluster that we've
> built
> which is running SQL 2005. We want to get all the databases on the SQL
> 2005
> cluster and retire the SQL 2000 server.
> Is there any way to rename the cluster? It seems to me that the easiest
> way
> would be to restore the databases from 2000 to 2005, take down the 2000
> machine, rename the 2005 cluster to have the same name as the old SQL 2000
> server and we're done.
> The other option is to bring down the 2000 server, but keep the 2005
> machine
> with the new name - problem is there's a lot of old code that has the
> connection strings hardcoded. It was suggested that we could do a DNS
> pointer to resolve the old server name to the new name, but that didn't
> seem
> to work with all of the apps that we've tested...
> Any suggestions? I haven't been able to find much advice on how to do a
> 2000 to 2005 upgrade when you're also switching servers. Thanks for your
> time.
|||That was the original plan. We did this in a test environment - old java
code we have that uses JDBC wasn't able to resolve the server name. Also, a
..net service that we tested didn't resolve the name correctly, either, which
is why I thought it wasn't going to work out. Perhaps there was a separate
isue with that service when we tested it. As far as you know, the DNS
solution should work pretty well?
Are there any "got'chas" or other downsides I should keep in mind?
Thanks for your time.
"Geoff N. Hiten" wrote:

> Why bother renaming? Create a DNS SRV record repointing the old name to the
> new server/instance.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Morgan" <Morgan@.discussions.microsoft.com> wrote in message
> news:66673D99-7035-491D-87EA-A10DE2A89FEB@.microsoft.com...
>

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 ***

Renaming a SQL 2000 Cluster

I need to migrate our SQL 2000 cluster to a new set of hardware and name
the new cluster with the same name as the existing one so that none of the
applications are affected. How do I change name of a SQL Cluster ?
Amila
Unfortunately, the only way to "Change" the virtual network name is to
uninstall and reinstall.
There are really only two choices: in-place system upgrade (rolling upgrade)
or a new cluster installation while aliasing the old SQL Server host name.
Read through the clustering news group as this question comes up quite
frequently.
Sincerely,
Anthony Thomas

"Amila chandrasekera" <achandra@.insight.com> wrote in message
news:O4HMyfDVHHA.4832@.TK2MSFTNGP04.phx.gbl...
> I need to migrate our SQL 2000 cluster to a new set of hardware and name
> the new cluster with the same name as the existing one so that none of the
> applications are affected. How do I change name of a SQL Cluster ?
>
> Amila
>
|||You can also have the older Cluster Virtual Name redirect to the newer name.
This would require NT Admin help but you dont need to do anything at the SQL
end as long as you are sure that you dont need the older cluster anymore and
can get rid of it.
"Anthony Thomas" wrote:

> Unfortunately, the only way to "Change" the virtual network name is to
> uninstall and reinstall.
> There are really only two choices: in-place system upgrade (rolling upgrade)
> or a new cluster installation while aliasing the old SQL Server host name.
> Read through the clustering news group as this question comes up quite
> frequently.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Amila chandrasekera" <achandra@.insight.com> wrote in message
> news:O4HMyfDVHHA.4832@.TK2MSFTNGP04.phx.gbl...
>
>
sql

Rename virtual SQL Server in cluster

Can I rename my virtual cluster name that has SQL 2005 installed after I
build it for example if the virtual name is MASTER_New to MASTER?
thanks,
Yes, check the books online for details.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>
|||You can rename the cluster network name resource, but not the instance name
(not without a lot of registry hacks).
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Sincerely,
Anthony Thomas

<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>

Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.

Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.
No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.

Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.sql

Rename SQL Server Virtual name in 2003 Cluster

Is it possible to change the current SQL virtual host name in Windows 2003?
and How?
I tried it by right click on the SQL Network name resource -> properties ->
parameters -> change the name. Then search the registry and change it to a
new name and reboot the node. It works but is there an easy way and is what
I did a safe procedure.
Thanks
Ayad
You sure can, see http://support.microsoft.com/?id=307336 for details
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:%239vieFHsEHA.760@.tk2msftngp13.phx.gbl...
> Is it possible to change the current SQL virtual host name in Windows
> 2003?
> and How?
> I tried it by right click on the SQL Network name resource ->
> properties ->
> parameters -> change the name. Then search the registry and change it to a
> new name and reboot the node. It works but is there an easy way and is
> what
> I did a safe procedure.
> Thanks
> Ayad
>
|||Thanks Rod. But I don't want to un-install and re-install SQL to change the
name.
Ayad
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You sure can, see http://support.microsoft.com/?id=307336 for details
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Ayad" <ashammout1@.hotmail.com> wrote in message
> news:%239vieFHsEHA.760@.tk2msftngp13.phx.gbl...
a
>
|||Ok, that's cool. You know you don't have to reinstall. It's right click
rename, then sp_dropserver old_virtualservername
go, sp_addserver new_virtualservername, local go, etc.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eEPiKeJsEHA.2904@.TK2MSFTNGP15.phx.gbl...
> Thanks Rod. But I don't want to un-install and re-install SQL to change
> the
> name.
> Ayad
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...
> a
>
|||Hi
Not much choice. Clustering is one of those technologies that you follow the
KB articles exactly otherwise the whole thing comes apart and you end up
re-installing everything.
Sorry.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eEPiKeJsEHA.2904@.TK2MSFTNGP15.phx.gbl...
> Thanks Rod. But I don't want to un-install and re-install SQL to change
the[vbcol=seagreen]
> name.
> Ayad
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23X1xRMIsEHA.2732@.TK2MSFTNGP09.phx.gbl...
to
> a
>
|||I agree with Mike. The ONLY SUPPORTED way to rename a virtual SQL name is to uninstall and reinstall as documented in Microsoft Knowledge Base article
INF: How to Change a Clustered SQL Server Network Name
http://support.microsoft.com/?kbid=307336
This article has the following important NOTE
"Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename. However, if you
rename the SQL Server Network Name resource, a variety of situations could occur, the most critical being that the SQL Server virtual server instance may no longer come
online. "
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Rename SQL Default instance in cluster

HI GROUP
I have my production sql server computer name "sql2k"
and of course the default sql instant name as "sql2k"
because they're running on same box aand stand alone
server.
I do have another active\active sql cluster in place
node1 name is sql1 node 2 name sql2 and virtual computer
name sqlcluster. My default sql instance name
is "sqlserver1"
and it running on Node1 with failed over using Node 2
My sql second instance name is "sql/server2" and it
running on Node 2 with failed over using Node1.
I would like to rename my "sqlserver1" sql instance name to
my production sql name is "sql2k, my plan is to uninstall
the sql default instant on node 1 and reinstall sql with
the my sql production name after shutdown my prodution sql
server. my question is do I need to rename the computer
virtual server name too or just sql instance name?
Do any one have any idea what will cause any problem to
rename sql instance in cluster and of course the cluster
will have diff ip address with sql production server
only the name will be transfer to my default cluster on
node 1. Please give me any opinion if you have with this
Thanks a lot
You can't rename a SQL Server instance in a cluster. The only way to
accomplish this is to uninstall SQL Server and reinstall it. There aren't
any issues to doing this that I'm aware of. Just keep the name under 13
chanracters.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Thanks
But I would like to transfer production sql name to the
default sql cluster name is it possible?
I know I can not have 2 sql name in the same network
but what if I shutdown my production and during the
reinstall sql on defaukt cluster Can I use my production
sql name for it? I still not clear if sql name using any
dns or wins like computer name on network if that the case
then where do I need to look for do a clean up of that name
before using it for my cluster?
Thanks a lot

>--Original Message--
>You can't rename a SQL Server instance in a cluster. The
only way to
>accomplish this is to uninstall SQL Server and reinstall
it. There aren't
>any issues to doing this that I'm aware of. Just keep
the name under 13
>chanracters.
>--
>Mike
>Principal Mentor
>Solid Quality Learning
>"More than just Training"
>SQL Server MVP
>http://www.solidqualitylearning.com
>http://www.mssqlserver.com
>
>.
>
|||Yes, you can reuse that name as long as the original server is offline. The
names that you use for the machine, cluster, and SQL Server are DNS
resolvable.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Rename SqL 2005 default instance and netbios name

I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:

> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>

Rename SqL 2005 default instance and netbios name

I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:
> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>

Rename Default Instance

Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
Technically, you can. However, Microsoft won't support it. Consider using
a DNS alias.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
|||Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:

> Technically, you can. However, Microsoft won't support it. Consider using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||Just like I said. From the KB article:
"However, renaming the SQL Server virtual, or clustered, servers is not
supported in the current version of Microsoft SQL Server. If you rename the
SQL Server Network Name resource, a variety of problems may occur. One of
the problems that may occur is that the SQL Server virtual server instance
may no longer come online. When this problem occurs, the following
information may be logged in the application event log: "
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:02537079-F255-49E1-9F19-B8CEA3C8C726@.microsoft.com...
Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:

> Technically, you can. However, Microsoft won't support it. Consider
> using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default
> instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||As pointed out by Tom, renaming a SQL Server clustered virtual servername is not supported. Since this is a new installation, I would uninstall and reinstall with a new virtual servername.
Additional Information:
======================
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?kbid=254321
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Rename Cluster Instance - New Hardware - Keep Name

Hello all,
We are moving a sql cluster to new hardware but would like to keep the same
server/virtual instance name.
Could anyone offer some advice on how to go about this or point us in the
direction of some Microsoft how to articles?
Many thanks, Simon
One method that may work is backing up the DBs from the existing instance,
taking the old instance down. Bringing up the new instance on the new cluster
hardware and performing a restore. You may also be able to backup the DBs
onto a volume on the new hardware (over the wire) and then perform a restore
on the new hardware using the .BAK files from the volume on the new hardware.
"Simon" wrote:

> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the same
> server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>
>
|||Windows clustering depends on unique names within a domain. Keeping an
existing name is almost impossible. You can use DNS to redirect the old
instance name to the new name. When I move servers I generally use a manual
log shipping process to bring the new server "close" to the old one. I then
stop connections to the old server, finalize the logs, apply them to the new
server, then bring the new one up. If you only have a few client machines,
you can set local aliases to redirect connections. Otherwise, DNS is your
friend. Look up the SVC record type for DNS. It allows you to map a name
to an IP address and a specific port.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Simon" <reply@.togroup.com> wrote in message
news:%23$37STSHGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the
> same server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>

Rename Cluster Instance - New Hardware - Keep Name

Hello all,
We are moving a sql cluster to new hardware but would like to keep the same
server/virtual instance name.
Could anyone offer some advice on how to go about this or point us in the
direction of some Microsoft how to articles?
Many thanks, SimonOne method that may work is backing up the DBs from the existing instance,
taking the old instance down. Bringing up the new instance on the new cluster
hardware and performing a restore. You may also be able to backup the DBs
onto a volume on the new hardware (over the wire) and then perform a restore
on the new hardware using the .BAK files from the volume on the new hardware.
"Simon" wrote:
> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the same
> server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>
>|||Windows clustering depends on unique names within a domain. Keeping an
existing name is almost impossible. You can use DNS to redirect the old
instance name to the new name. When I move servers I generally use a manual
log shipping process to bring the new server "close" to the old one. I then
stop connections to the old server, finalize the logs, apply them to the new
server, then bring the new one up. If you only have a few client machines,
you can set local aliases to redirect connections. Otherwise, DNS is your
friend. Look up the SVC record type for DNS. It allows you to map a name
to an IP address and a specific port.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Simon" <reply@.togroup.com> wrote in message
news:%23$37STSHGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the
> same server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>

Rename Cluster Instance - New Hardware - Keep Name

Hello all,
We are moving a sql cluster to new hardware but would like to keep the same
server/virtual instance name.
Could anyone offer some advice on how to go about this or point us in the
direction of some Microsoft how to articles?
Many thanks, SimonOne method that may work is backing up the DBs from the existing instance,
taking the old instance down. Bringing up the new instance on the new cluste
r
hardware and performing a restore. You may also be able to backup the DBs
onto a volume on the new hardware (over the wire) and then perform a restore
on the new hardware using the .BAK files from the volume on the new hardware
.
"Simon" wrote:

> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the sam
e
> server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>
>|||Windows clustering depends on unique names within a domain. Keeping an
existing name is almost impossible. You can use DNS to redirect the old
instance name to the new name. When I move servers I generally use a manual
log shipping process to bring the new server "close" to the old one. I then
stop connections to the old server, finalize the logs, apply them to the new
server, then bring the new one up. If you only have a few client machines,
you can set local aliases to redirect connections. Otherwise, DNS is your
friend. Look up the SVC record type for DNS. It allows you to map a name
to an IP address and a specific port.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Simon" <reply@.togroup.com> wrote in message
news:%23$37STSHGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> We are moving a sql cluster to new hardware but would like to keep the
> same server/virtual instance name.
> Could anyone offer some advice on how to go about this or point us in the
> direction of some Microsoft how to articles?
> Many thanks, Simon
>