Options
How do I edit/delete existing log shipping?
Multiplex
Posts: 3
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?
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?
Comments
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.