Disabling - Log shipping

myron

Hi,

I am new to Red-Gate's SQL Back up and I would like to ask where do I temporarily disable log shipping.. do I disable it on Red-Gate software or disable it on the SQL Server itself?

I need to temporarily disable it because I will be powering down the other machine that would be receiving the log shipping files.

Thanks in advance

petey

Log shipping in SQL Backup is implemented using a pair of SQL Server Agent jobs, one on the primary server to perform the backups, and another on the standby server to perform the restores.

To answer your question, it depends on what you want to do with regards to the backups.

-> If you want to backups to continue, just let the backup job run as usual. You might need to change the COPYTO option, if you were previously copying to the standby server. When the standby server is back online, then copy all the transaction log backups that have been created, to the standby server. The restore job will apply these backups when it next runs.

-> If you want to stop the backups, you need to disable the backup job on the primary server. By default, the job has the name 'Log shipping: backup [database name]