Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Q: SQL FAQ: Stopping database mirroring
You can use the ALTER DATABASE command to stop database mirroring. This will leave the database in a restoring state.
Michael Otey
May 27, 2010
1 Min Read
Q: How do I stop database mirroring?
A: You can use the ALTER DATABASE command to stop database mirroring.
ALTER DATABASE SET PARTNER OFFThis 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 RECOVERYAbout the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)