How do I edit/delete existing log shipping?

Multiplex

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?

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.

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?

Chris Auckland

That's correct. a FULL backup of the source database.