I am running log shipping with SQL server 2008 R2.
I have a situation where the secondary database drive ran out of space and was not applying log shipping transaction logs.
The way I want to fix this is delete the databases at the secondary and configure log shipping from scratch.
The problem I have now is that my secondary databases are in the restoring state, and I cannot delete them. How can I proceed?
For instance if I try to take them offline I get the error,
ALTER DATABASE is not permitted while the database is in the Restoring state.