What are the challenges you face when working across database platforms? Take the survey
Options

Stop and re-start Log Shipping

geoff.tannergeoff.tanner Posts: 8
edited August 29, 2010 8:24PM in SQL Backup Previous Versions
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?
Geoff Tanner
Lead SQL DBA
Wishlist
Port Melbourne Australia

Comments

  • Options
    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
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • Options
    Thanks, Peter, I will use that technique in the future
    Geoff Tanner
    Lead SQL DBA
    Wishlist
    Port Melbourne Australia
Sign In or Register to comment.