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

How to stop/terminate an existing Logshipping job

vad2319vad2319 Posts: 40
edited February 18, 2009 9:51PM in SQL Backup Previous Versions
We have a logshipping job that transfers data from source to the destination server. Now due to space constraints we would have to cancel this logshipping job. how can I do it?

Thanks!!!

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Log shipping in SQL Backup is implemented using a SQL Server Agent job on the primary server that backs up the logs and copies them to the secondary server, and another SQL Server Agent job that restores the transaction logs and moves the restored files to a 'processed' folder.

    To stop log shipping, disable or delete these jobs on the primary and secondary servers, using Query Analyzer or Management Studio.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.