Consolidation of server

We have two production servers and SQL is running on both servers. The
databses in two production srevers has same name. I am in process of
consolidating server. I have to move all the datbases to another sql server
in the other box. But now i have a problem. Since dtabase name is same i am
stuck can any body help me to sort this out.
Thanks ....
You can install a separate named instance on the server, therefore you can
keep the same dbname.
http://msdn.microsoft.com/library/de...stall_259u.asp
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
news:861FD285-C52D-4369-9FFE-419F99028232@.microsoft.com...
> We have two production servers and SQL is running on both servers. The
> databses in two production srevers has same name. I am in process of
> consolidating server. I have to move all the datbases to another sql
> server
> in the other box. But now i have a problem. Since dtabase name is same i
> am
> stuck can any body help me to sort this out.
> Thanks ....
|||Thanks so much jens. I installed it. But i do i switch over between 2
instances. Does the same enterprise manger works.
"Jens Sü?meyer" wrote:

> You can install a separate named instance on the server, therefore you can
> keep the same dbname.
>
> http://msdn.microsoft.com/library/de...stall_259u.asp
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:861FD285-C52D-4369-9FFE-419F99028232@.microsoft.com...
>
>
|||YOu habe to tregister the server within the Enterrise Manager, the
servername of a named instance is
Servername\InstanceName
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Harsha" <Harsha@.discussions.microsoft.com> schrieb im Newsbeitrag
news:509CBA13-244E-4C6C-BC15-1E9789FB2AAE@.microsoft.com...[vbcol=seagreen]
> Thanks so much jens. I installed it. But i do i switch over between 2
> instances. Does the same enterprise manger works.
> "Jens Smeyer" wrote: