• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

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?
0
datadirector
Asked:
datadirector
1 Solution
 
chapmandewCommented:
not sure you need to bring them back online to remove them...you 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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now