multi database migration RRS feed

  • General discussion

  • Hi ,

    database population

    • Changed type ESQL5 Thursday, July 6, 2017 7:51 PM
    • Edited by ESQL5 Tuesday, August 1, 2017 6:41 AM
    Thursday, July 6, 2017 7:01 PM

All replies

  • Log shipping will work well here. This will allow for a coordinated cut over to the new system.

    Thursday, July 6, 2017 7:15 PM
  • Restore the full with no recovery.

    Restore the tlogs in order with no recovery. Keep copying the logs from the current server to the new server.

    When you are ready to cut over do tail log backups on the current server, copy them over and then restore them with recovery.

    You should use sp_help_revlogin to extract all the logins and passwords and run the results of this script on the new server.

    Thursday, July 6, 2017 7:32 PM