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

How do I edit/delete existing log shipping?

So we had network issue causing the destination to miss a few SQB file. The source have already deleted those SQB file so there is no way of manually copying the file.

I have been advised I need to recreate the log shipping job from scratch. But I am faced with a few issue

I cannot see/find any option to delete the existing log shipping. When I right click the DB in red gate, Properties only show info and log shipping takes me to a GUI to create a new log shipping.

Can someone provide information or point me to the right direction to get this software running again?
Multiplex
0

Comments

3 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    SQL Backup log shipping jobs are created as SQL Agent jobs in SQL Server. If you want to delete the exiting jobs, then the only way to do it is through the SQL Agent.

    If you are happy with the existing log shipping configuration, then you could restart the process by reseeding rather than starting again from scratch.

    See the link below for instructions:
    http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Backup\KB200901000347.htm&p=SQL%20Backup

    I hope this helps.
    Chris Auckland
    0
  • Multiplex
    Thanks for the reply. The instruction mentioned in the link said take a seed backup, does that mean take a full backup with redgate (SQB extension) and restore it to destination?
    Multiplex
    0
  • Chris Auckland
    That's correct. a FULL backup of the source database.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.