July 8, 2005 at 11:10 am
I am planning the migration from our old SQL 7 Server to a new machine running SQL 2000. The new machine has a different name for the moment, but I need to ultimately maintain the same name as the old server.
How could I transfer everything onto the new server but then rename the machines once we're up and running? I looked for articles but could not find anything that addresses this specifically.
Thanks!
July 8, 2005 at 11:24 am
Once you get everything converted, stand down the old machine. The safest mechanism to rename a machine with respect to the domain is:
1) Move system into a workgroup. Reboot.
2) Rename system. Reboot.
3) Rejoin domain. Reboot.
Of course, Active Directory seems to be better about renaming without dropping into a workgroup but us old curmudgeons still do it the tried and true method. After the system is renamed, you'll need to rename SQL Server internally. Here's a KB article on it. Originally BOL didn't contain all the info needed so they posted a KB that updates with the correct info. BOL has since been updated, but the KB article still exists:
BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete (303774)
K. Brian Kelley
@kbriankelley
July 8, 2005 at 11:48 am
Thank you! That discrepency in the BOL was what I got caught up on before so it got me thinking that I could not rename an instance of SQL.
I appreciate your prompt help!
July 8, 2005 at 12:00 pm
If you have that discrepancy in your BOL, you should go ahead and grab the latest version of BOL:
SQL Server 2000 Books Online January 2004 Update
K. Brian Kelley
@kbriankelley
July 8, 2005 at 2:32 pm
I would like to add that you can rename and still start SQL Server in 6.5 and 2000 and then follow sp_dropserver sp_addserver recommendations per Brian's link
With SQL server 7 you would need to re-run the setup (not to reinstall, but just insert a setup disk) if you rename your server. You will be prompted to upgrade and the setup program will reset the name.
I also would like to add that some other SW does not support name change like Microsoft BizTalk 2000. I am not sure about the latest versions. Please, check with your application manuals.
Hope everything will migrate well,
Yelena
Regards,Yelena Varsha
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply