Upgrade with New Machine - Same Name

  • 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!

  • 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

  • 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!

  • 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

  • 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