February 26, 2009 at 7:29 am
Can we put the database in single user mode if database is configured for Database mirroring....
Actually we have one problem here....Our application sometimes put the database in single user mode...But is there any way for that...
Thanks in advance.
February 26, 2009 at 1:02 pm
You could, as long as your mirroring session takes the first connection to the database ... but then you wouldn't be able to access the database in any other fashion, rendering it quite useless. I would not recommend this unless it's for some maintenance window in which you can control the connections properly and then re-enable multi-user.
I'm curious now ... why would your application put your database into single user mode?
February 26, 2009 at 6:36 pm
I am also curious why an App would put a DB in single_user mode!
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply