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