This may seem like a dumb question but I did not see anything in the forum - how does one stop and re-establish a log shipping job in SQL Backup? The obvious way seems to be to delete both jobs and create another log shipping job. Is there anything else that needs to be dealt with?
Comments
2 comments
-
Hi Geoff,
Rather than deleting the job, you can just stop and start them in SSMS. The jobs are simply SQL Agent jobs which make use of the extended stored procedure that SQL Backup installs, so there isn't a need to do anything as draconian as deleting your log shiping jobs.
HTH!
Pete -
Thanks, Peter, I will use that technique in the future
Add comment
Please sign in to leave a comment.