Sql-server – Unable to delete Log Shipping configuration

log-shippingsql serversql-server-2005

I need some help with my SQL 2005 server.
I am trying to setup log shipping, I've successfully done so for all user-databases, except one.
From the looks of it, it once had log shipping configured until the secondary server was decommissioned before log shipping could be deleted. The old DBA deleted the old jobs.

So what's left is a database that is configured for log shipping, but the LSBackup job has been deleted.
Which means, every time I try to open the log shipping configuration wizard, I am told that the job does not exist and to delete the configuration (Seems sensible).
But I can't delete it because it is trying to connect to the secondary server… which does not exist so just times out and fails.

Any suggestions would be much appreciated!

Best Answer

If something is still setup on the secondary server you need to run sp_delete_log_shipping_secondary_database there.

You can clear the log shipping configuration on the primary by executing sp_delete_log_shipping_primary_secondary

USE master;
GO
EXEC master.dbo.sp_delete_log_shipping_primary_secondary
    @primary_database = N'<PrimaryDatabase>'
   ,@secondary_server = N'<SecondaryServer>'
   ,@secondary_database = N'<SecondaryDatabase>'
GO