Jigsaw Blog

15

Oct
2013
0 comments

How to suspend and resume SQL database mirroring

There are times when you need to perform an operation that requires database mirroring to be suspended. A good example is when putting the database into single user mode.

Here's how to do it.

alter database [db name here] set partner suspend;

 alter database [db name here] set partner resume;