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