Red Gate forums :: View topic - How do I edit/delete existing log shipping?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

How do I edit/delete existing log shipping?

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Multiplex



Joined: 10 Aug 2010
Posts: 2

PostPosted: Tue Aug 10, 2010 2:37 am    Post subject: How do I edit/delete existing log shipping? Reply with quote

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?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Aug 11, 2010 10:48 am    Post subject: Reply with quote

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/Content.aspx?c=knowledgebase\SQL_Backup\KB200901000347.htm&p=SQL%20Backup

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Multiplex



Joined: 10 Aug 2010
Posts: 2

PostPosted: Wed Aug 11, 2010 11:21 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Wed Aug 11, 2010 11:22 am    Post subject: Reply with quote

That's correct. a FULL backup of the source database.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group