Post reply

How to move SQL Server engine, databases, jobs to a new server?

  • August 30, 2005 at 2:53 pm

    #89596

    Hi friends!

    I have a new hardware to migrate all databases, engine, jobs, maintenance plans, dblinks and so on. I will install this server With Win2003, SQL2000 SP3, like the old server.

    So, the question is, what is the best way to move all the 'SQL Architecture' from one server to the other (New server, not running SQL yet)

    I found this on Support page:

    http://support.microsoft.com/default.aspx?kbid=314546#top

    is this the best way?

    Thanks for help

  • August 30, 2005 at 3:39 pm

    #586303

    Is the old server is going away?

  • August 30, 2005 at 3:41 pm

    #586306

    Yes... i will replace the old server

  • August 30, 2005 at 5:31 pm

    #586320

    Martin,

    That's just about the best article you'll find.  I've used all three methods (detach/attach, export/import, backup/restore) to move databases and they all work.  You may get other suggestions for how to move jobs, DTS packages, etc. but you can't go wrong with scripting them out as the KB article describes.

    Greg

    Greg

  • August 30, 2005 at 5:53 pm

    #586323

    For logins  You can scripts them (using Query Analyser) this will eliminate Orphaned Users section

     

     

     

     

    Kindest Regards,

    Amit Lohia

  • August 30, 2005 at 6:09 pm

    #586325

    Thanks for the information, but what do you think about this article?

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

     

    Thanks for the advices...

     

  • August 31, 2005 at 7:32 pm

    #586703

    Hello Martin,

    The original KB article that you have listed contains good information on how to move your databases, DTS packages and jobs to the new server and it also contains a very good link to a KB Article on how to move the logins.  I've used the sp_help_revlogin for a long time without having problems with orphaned users. 

    thx

    debrunkle  


    Deborah Runkle

  • September 1, 2005 at 6:29 am

    #586784

    Thanks for the advice, i want to tell everybody that the article i have published (how to move the whole SQL to another HW), works fine on a SQL 2000 SP3 + Analisys services SP3.

    Just, stop the services on both servers, copy the entire MSSQL folder to the target, start the service on the target server, run the SP_ADDSERVER and SP_DROPSERVER to re-register with the new name (if u dont rename the new server with the name of the original server) a restart the machine.

    Regards.

     

Viewing 8 posts - 1 through 7 (of 7 total)

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