February 10, 2014 at 9:47 am
After completely restoring a server using Symantec system recovery 2013, the SQL server was functioning, but sql server management studio shows that the master database is in single user mode. I am not experiencing any issues in operation, and I seem to be able to connect to the master database with more than one user. When I run “select databasepropertyex ('master', 'useraccess')”, it says it is in multi_user mode. However, If I run “select * from sys.databases where name ='master'”, it says it is in single_user mode.
Symantec is aware of this issue - see article at (www.symantec.com/business/support/index?page=content&id=TECH210791). I'm confused though - the documentation for "sp_dboption" or the more modern "alter database" commands seem to indicate you can't use them to set options on the master database.
I haven't tried restoring the master database - I have a backup, but I'm reluctant to cause more downtime on the server after the time we lost doing the server restore.
Any suggestions about what's going on, or where I could go from here?
February 10, 2014 at 10:37 am
I have seen this happen at a client for the following reasons.
Master database files were deleted (by the hosting service). The backup was restored on a different server and then the data and log file copied over to the "down" server to the appropriate locations. Because the database was restored on a different server adn then the files copied, master thinks there is a mismatch and shows in SSMS as being in single_user mode - but it isn't.
The trick is to restore the master database. In the case of this client they opted to leave it as is because it was causing any problems.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 10, 2014 at 2:08 pm
Never mind. This is master database. Retracted.
February 19, 2014 at 7:27 am
Thanks. I thought that might be the only answer - but I wasn't going to go there unless I had to. it helps to have some explanation of what I'm seeing.
February 19, 2014 at 7:30 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply