How do I edit/delete existing log shipping?

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

How do I edit/delete existing log shipping?

Postby Multiplex » Tue Aug 10, 2010 2:37 am

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
 
Posts: 2
Joined: Tue Aug 10, 2010 2:28 am

Postby Chris Auckland » Wed Aug 11, 2010 10:48 am

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Multiplex » Wed Aug 11, 2010 11:21 am

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
 
Posts: 2
Joined: Tue Aug 10, 2010 2:28 am

Postby Chris Auckland » Wed Aug 11, 2010 11:22 am

That's correct. a FULL backup of the source database.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests