SQL SELECT Blog

Q: SQL FAQ: Stopping database mirroring

Q: How do I stop database mirroring?

A: You can use the ALTER DATABASE command to stop database mirroring.

ALTER DATABASE SET PARTNER OFF

This will leave the database in a restoring state. To complete the restore and make the database usable you can run the following RESTORE DATABASE command.

RESTORE DATABASE WITH RECOVERY

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish