Restore and remove database

We previously had some of our databases mirrored with a witness server instance, however we no longer needed them to be mirrored and have since removed the mirroring. Now on our mirror server the database says it is Restoring...

What is the easiest way to bring them back online so we can remove them?
Who is Participating?
chapmandewConnect With a Mentor Commented:
not sure you need to bring them back online to remove can probably just do this:

use master
drop database dbname

if not, then you can do this

restore database dbname with recovery
drop database dbname
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.