October 29, 2012 at 7:49 am
The Master database on one of our servers is showing in SSMS as Single-user mode. I have tried to change it back to multi-user, but am getting error "Option 'MULTI_USER' cannot be set in database 'master'". Weirdly, I am able to connect to the database and make changes to it.
Sys.databases is reporting user_access as 'SINGLE_USER'
However, sp_helpdb 'master' reports "user_access=MULTI_USER"
DBCC CHECKDB returns nothing of interest
The error logs all look fine, too.
I understand that another instance of SQL Server was installed on the same server recently, though that is used by another department, and I don't have access to that instance. Could this have caused this confusion?
Our infrastructure providers are saying that this inconsistency is only a GUI issue, so we shouldn't be concerned. However, I am concerned that this could be indicative of a wider problem with the database and that they are trying to sweep it under the carpet.
Can anyone shed any light on these inconsistencies?
Thanks
December 18, 2012 at 5:54 am
Do you know what versions the two instances are? For example, one being 2008 and the other 2008 R2? Or are there any discrepancies between the service packs?
February 11, 2014 at 12:29 pm
one of my peers is reporting the same situation on one of our servers. 2005.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply