• SQLRNNR (2/12/2014)


    That will work.

    But why not apply those transaction log backups to the target as the backup occurs? You could logship those databases and keep them in sync and then the final cutover requires one last log backup and setting the original databases to read only. This method would save you significant time the night of the final cutover.

    Nahhh, that won't work.

    It would leave the DB's on the target in Read-Only mode, thus defeating our objective to create/run packages that will write data to the DB's.