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/default.asp?url=/library/en-us/howtosql/ht_install_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/default.asp?url=/library/en-us/howtosql/ht_install_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 ....
>
>|||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...
> 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/default.asp?url=/library/en-us/howtosql/ht_install_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 ....
>>