Can you place a SQL2005 Mirrored principle database in single user mode?

• John Burke-413068

  SSC-Addicted

  Points: 417

  More actions

  October 6, 2010 at 9:02 am

  #157240

  Hello

  Anyone know if you can place a SQL2005 Mirrored principle database in single user mode without breaking the mirror?

  E.g.

  I can put database in single user mode after breaking mirror (ALTER DATABASE mydb set PARTNER off) but can't do it when I suspend mirroring (ALTER DATABASE mydb set PARTNER suspend).

  Thanks

  John

• TheRedneckDBA

  SSChampion

  Points: 14001

  More actions

  October 6, 2010 at 2:15 pm

  #1233026

  Just out of curiosity, why would you want to do this?

  The Redneck DBA