Manually, using T-SQL :
1. On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.
EXEC master.dbo.sp_delete_log_shipping_primary_secondary
@primary_database = N'AdventureWorks'
,@secondary_server = N'LogShippingServer'
,@secondary_database = N'LogShipAdventureWorks'
GO
2. On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database.
sp_delete_log_shipping_secondary_database N'LogShipAdventureWorks'
3. On the primary server, execute sp_delete_log_shipping_primary_database to delete information about the log shipping configuration from the primary server. This also deletes the backup job.
sp_delete_log_shipping_primary_database N'AdventureWorks'
Worked perfectly! My secondary server was not accessible and I wasn't able to tear down log shipping using SQL Management Studio. Thanks a bunch!
ReplyDeletelooks nice. but have you ever heard about another way of access database query recovery, provided by appropriate data recovery services?
ReplyDeletePerfect, it works properly.
ReplyDeleteThis is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. https://europa-road.eu/hu/gepszallitas.php
ReplyDelete