none
Moving SQL Server to a new machine; downtime?

    Question

  • Quick question.  Is it common to have some down time when moving sql server databases to a new physical machine?  
    Thursday, September 05, 2013 6:55 PM

Answers

  • I would say absolutely.  No matter how you go about migrating to the new server, there's going to be a period where the apps won't be able to talk to the DB.  Either while you're restoring a backup to the new server (this could be minimized by leaving the DB on the new server in recovery, and then taking a TLog backup on the old before offlining the DB,) copying the MDF / NDF / LDFs (if you choose to do the deattach / reattach method,) changing the connection string(s) in the app(s), or waiting for the DNS update to propogate through your DNS system.

    Jason A.

    • Marked as answer by Diango Friday, September 06, 2013 1:22 AM
    Thursday, September 05, 2013 7:15 PM

All replies

  • I would say absolutely.  No matter how you go about migrating to the new server, there's going to be a period where the apps won't be able to talk to the DB.  Either while you're restoring a backup to the new server (this could be minimized by leaving the DB on the new server in recovery, and then taking a TLog backup on the old before offlining the DB,) copying the MDF / NDF / LDFs (if you choose to do the deattach / reattach method,) changing the connection string(s) in the app(s), or waiting for the DNS update to propogate through your DNS system.

    Jason A.

    • Marked as answer by Diango Friday, September 06, 2013 1:22 AM
    Thursday, September 05, 2013 7:15 PM
  • It is very common.

    You can minimize it using hot standby database on new SQL server machine by using Database Mirroring, Transaction Ship Logging, Always On Availability Groups, ...


    Regards, Dean Savović

    Thursday, September 05, 2013 7:17 PM