Jake Shelton (2/13/2014)
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.
Yes it would work. Logshipping is just the preparation work and could be done days or weeks in advance.
Once you are ready, you only need to restore the final tlogs and bring the db fully online (and writable).