Soo if you are like me, who deleted a database from the primary server that was used for log shipping and no one told you about it prior, that means the traditional way of stopping log shipping doesn’t seem possible … and you got a database that is stuck in restoring mode.
All you have to do to get the database out of restoring mode is:
restore database dbname with recovery
or if that doesn’t work and you get the error:
The database cannot be recovered because the log was not restored.
Then just run: drop database database_name