Q: SQL FAQ: Stopping database mirroring

RSS

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

Please or Register to post comments.

What's SQL SELECT Blog?

SQL Server news, FAQs, tips, and techniques from Michael Otey, technical director for SQL Server Pro.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×