Today I faced an issue where one of secondary server box is now not available due to some circumstances, now I have to delete this secondary server Name and Database entry from primary server’s database. If we go through log shipping wizard from Database property page and try to remove secondary server it will ask to connect secondary server but in my case secondary server is now not available with us. To resolve this, here is a script to delete secondary server entry from primary server’s database is: ( in this case there is no need to connect secondary server)
EXEC Master.dbo.sp_delete_log_shipping_primary_secondary
@primary_database = N’VirendraTest’,
@secondary_server = N’VIRENDRA_PC’,
@primary_database =N’LSVirendraTest’;
GO
Please don’t forget to comment on this and your experinces about it.
WikiDBA 