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?

Rename SQL 2005 Instance

Hi,

I have a SQL Server 2005 installation, running under the instance of MyServer\SQL2005. So I have 1 instance called 'SQL 2005'.

I would like to rename the instance back to the default instance. So afterwards, the server instance should just be called 'MyServer'. Does anyone know if this is possible without loosing any data?

Thank you

Jeremy

I don't think it's doable

I searched around when I tried to change my default instance install to named instance - can't do it

had to uninstall, and re-install again

as long as you don't delete your MDF/LDF files, you shouldn't lose much (backup first anyway)

|||

Thanks for your reply,

This is what I was fearing.....although it is strange that Microsoft specificly ship the AS instance rename tool. Yet there's no indication of how you can do this for the database engine.

If anyone does know of a method it would be appreciated,

Thanks

Jeremy

|||

Jeremy,

You can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance.

Ron

|||http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/e9065e05718e984e

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 a file without xp_cmdshell

Hi:

By default xp_cmdshell is disabled on new Installation of SQL Server 2005. I want to know how do I rename a file without using xp_cmdshell option?. What are my options programmatically to rename a file without using xp_cmdshell from T-SQL. One option is to create a Active x VB Script that uses the file system object to rename a file in a DTS package and then run the package.

Any ideas would be higly appreciated.

Thanks

Meher

you may use a CLR functions to achive such a requirement

Removing SQL server from SBS 2003 server

I think I screwed up with the installation of SQL server and would like to
remove it. My only fear is that if I use the add and remove option in
Control Panel would this actually remove my MSDE instances used for
Sharepoint Services? I've notice that the MSDE portion of SQL gets installed
at C:\Program Files\Microsoft SQL Server. I installed a new instance of SQL
Server at D:\Program Files\Microsoft SQL Server. This is the instance I want
to remove.
See http://support.microsoft.com/default...b;en-us;290991 for
additional information.
Adrian
"AllenM" <allen@.majaro.com> wrote in message
news:OratwJoUFHA.3716@.TK2MSFTNGP12.phx.gbl...
>I think I screwed up with the installation of SQL server and would like to
>remove it. My only fear is that if I use the add and remove option in
>Control Panel would this actually remove my MSDE instances used for
>Sharepoint Services? I've notice that the MSDE portion of SQL gets
>installed at C:\Program Files\Microsoft SQL Server. I installed a new
>instance of SQL Server at D:\Program Files\Microsoft SQL Server. This is
>the instance I want to remove.
>

Removing SQL server from SBS 2003 server

I think I screwed up with the installation of SQL server and would like to
remove it. My only fear is that if I use the add and remove option in
Control Panel would this actually remove my MSDE instances used for
Sharepoint Services? I've notice that the MSDE portion of SQL gets installed
at C:\Program Files\Microsoft SQL Server. I installed a new instance of SQL
Server at D:\Program Files\Microsoft SQL Server. This is the instance I want
to remove.See http://support.microsoft.com/default.aspx?scid=kb;en-us;290991 for
additional information.
Adrian
"AllenM" <allen@.majaro.com> wrote in message
news:OratwJoUFHA.3716@.TK2MSFTNGP12.phx.gbl...
>I think I screwed up with the installation of SQL server and would like to
>remove it. My only fear is that if I use the add and remove option in
>Control Panel would this actually remove my MSDE instances used for
>Sharepoint Services? I've notice that the MSDE portion of SQL gets
>installed at C:\Program Files\Microsoft SQL Server. I installed a new
>instance of SQL Server at D:\Program Files\Microsoft SQL Server. This is
>the instance I want to remove.
>

Removing SQL server from SBS 2003 server

I think I screwed up with the installation of SQL server and would like to
remove it. My only fear is that if I use the add and remove option in
Control Panel would this actually remove my MSDE instances used for
Sharepoint Services? I've notice that the MSDE portion of SQL gets installed
at C:\Program Files\Microsoft SQL Server. I installed a new instance of SQL
Server at D:\Program Files\Microsoft SQL Server. This is the instance I want
to remove.See http://support.microsoft.com/defaul...kb;en-us;290991 for
additional information.
Adrian
"AllenM" <allen@.majaro.com> wrote in message
news:OratwJoUFHA.3716@.TK2MSFTNGP12.phx.gbl...
>I think I screwed up with the installation of SQL server and would like to
>remove it. My only fear is that if I use the add and remove option in
>Control Panel would this actually remove my MSDE instances used for
>Sharepoint Services? I've notice that the MSDE portion of SQL gets
>installed at C:\Program Files\Microsoft SQL Server. I installed a new
>instance of SQL Server at D:\Program Files\Microsoft SQL Server. This is
>the instance I want to remove.
>