Log shipping set up when transaction logs already exist

RichardRayJH

The setup wizard for Log Shipping seems to expect that it's the first time tran logs are getting backed up for the source database. If I'm already do 15 minute tran log backups and copying them to a network share, how do I tell SQL Backup to use those for the source logs instead of creating another set?

petey

Take a look at this article first, which should get you started on setting up a job on the secondary server to restore the log files.

You'll see that during log shipping, SQL Backup uses file search patterns to identify the backup files to restore. However, it doesn't keep track of which files it has already restored, so it needs to move the files it has already restored to another location, using the MOVETO option, so that the same files don't get picked up for subsequent restores.

RichardRayJH

Thanks. In this application the db to which I want to ship the logs is a testing and development db that really only needs to be kept up to date nightly. It seems like it would work quite nicely to just queue up the logs and then run a job to integrate them into the target db once a day.

In any event, that article covers all the bases quite completely, thanks.