Post reply

What DBA should do when we plan to have server swapped out?

  • December 21, 2004 at 9:31 am

    #87353

    Hi experts,

        We bought new server to replace old server where contains one of our SQL Server 2000.  What a DBA should prepare to preform this server swap-out job?

    Thanks. 

  • December 21, 2004 at 11:03 am

    #534646

    Check this out.

    http://vyaskn.tripod.com/moving_sql_server.htm

  • December 21, 2004 at 12:18 pm

    #534662

    Thanks, this is exactly what I need.

  • December 22, 2004 at 6:34 am

    #534742

    Here is what I did a month ago when we swapped out boxes...

    Set up new box using <oldservername>2 (we are going to name the new box the same as the old box).

    Install SQL Server

    Detach Databases on old box, copy them to new box and re-attach them (including MSDB - special case).

    Rename old box to <oldservername>3.

    Rename new box to <oldservername>

     

    It worked really slick.  You may have a few issues with ODBC on client boxes where you simply can refresh the ODBC link to the box.

     

    Good Luck!!!

     

    Marty

  • December 22, 2004 at 1:21 pm

    #534821

    I used the file copy method listed on the link earlier.  Somewhat to my surprise, it worked almost without a hitch -- I only had to fix a few (but not most) logins later.

    Jill

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply