April 22, 2008 at 2:32 pm
Hello...first off please bare with me as I am new to this. I kind of inherited this situation and this may be (hopefully) a simple thing to resolve. Question - how does a db automatically convert from multi-user mode to single-user mode? We have a "training db" of sorts that when a user logs into the db it converts to single-user mode preventing the rest of the class from logging in. Any ideas or suggestions will be greatly appreciated.
I thank you in advance for your time.
April 22, 2008 at 2:51 pm
A database server is designed for multiple users. I do not think it will automatically be changed to a single-user mode.
Yes, we can set it in the single-user mode in the properties of a database, or run a script to change it.
April 22, 2008 at 3:00 pm
I agree. I would not think it would do that automatically either but it is happening. This is happening to a db we restored from backup into a new db with a new name for training purposes. Now whenever one person logs in it changes to single-user mode. This is the only db in SQL it is happening to. We have tried restoring again but end up with the same results. We are stumped as well.
April 22, 2008 at 3:19 pm
Check the database setting. If it is set to single-user mode, change it multiple user mode.
If it is set in the multiple user mode, check whether or not there is any malicious stored procedure in the startup.
But I believe that most likely, it is the former.
January 3, 2011 at 11:06 am
I am currently having this issue with one of my databases. It is the only one of 25 dbs that is doing this and I can't figure out what would be causing it. Almost daily I have to go in and reset it to multi-user as it keeps reverting to single-user.
The database is a restore from a backup of a template that I created and no others restored from that template are experiencing this issue.
Does anyone have any ideas as to what I could do to fix this?
Thank you!!
January 3, 2011 at 11:24 am
Edit: No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1041962-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply