Removing SQL Instance Name

Hi,
I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
want to have the server without any instance name. I want to keep all
the databases and data as it is. How can i remove the instance name?
ie. from "servername\vsdotnet" to "servername" alone.
Thanks,
Senthil.
- copy off the mdf and ldf files to a safe location
- uninstall the named instance
- install the default instance
- copy back the mdf and ldf files and attach them
Vikram
Vikram Vamshi
Eclipsys Corporation
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.c om...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.
|||Hi,
Only way is to backup the dabases, Remove the existing instance and install
a default instance and Restore the backed files.
Other option is detach databases , Remove existing named instance, Install
default and Attach the
Steps:-
1. Start SQL Server in single user mode
2. Perform a backup (BACKUP database) of all databases. COpy the .BAK files
to safe loaction.
3. After this for safe pupose use SP_DETACH to Detach the databases
4. Copy the MDF and LDF files to a safe place
5. Remove named instance using COntrol panel -- add remove programs
6. Install SQL Server default instance and apply the same service pack as
old
7. Restore the Master database after starting the SQL Server in single user
mode.
8. After the Master database restore restore the other databases one by one.
Have a look into the below links for more information on moving datases with
various methods:-
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Note:
Please ensure that you take a backup and keep it in a safe place before
removing the named instance.
Thanks
Hari
MCDBA
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.c om...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.
|||Thanks a lot Vikram and Hari for your replies and links.
Regards,
Senthil.
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message news:<#YETuLyVEHA.3428@.TK2MSFTNGP12.phx.gbl>...
> - copy off the mdf and ldf files to a safe location
> - uninstall the named instance
> - install the default instance
> - copy back the mdf and ldf files and attach them
> Vikram
> --
> Vikram Vamshi
> Eclipsys Corporation