|
|
Posted by Erland Sommarskog on 09/22/05 00:35
snewell2003 via SQLMonster.com (forum@SQLMonster.com) writes:
> I am wondering if this is able to be done and what implications there
> would be with SQL Server.
>
> Server1 name: Production Currently running Windows NT and SQL 7
> instance name is Production
> Server2 name: Test Currently running Windows 2000
> and SQL 2000, instance name is Test - default installation
Is that Test\Test or just Test? Production is obviously not
Production\Prodction as there are no named instances on SQL 7.
> Bring the Server1 offline and rename Server 2 with the name of
> Production. Do we have to change the instance name in SQL now on Server
> 2? If so can we do this? I didn't think you could change a instance
> name and had to reinstall SQL.
If SQL 2000 is a default instance, this should not be difficult. There
is one thing you need to once you have moved:
EXEC sp_dropserver Test
go
EXEC sp_addserver, Production, LOCAL
And the reboot afterthis. Else @@servername will be wrong.
> Can you have 2 instances of SQL with the same name but reside on different
> servers?
As long as the machines are not connected to each other. if they are on
the same network, I would not recommend it.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|