How can we help you today? How can we help you today?

How to stop/terminate an existing Logshipping job

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!!!
vad2319
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.