K
Kevin Watson
The primary SPS database sets itself to single user mode after every backup.
I changed the single user mode back to normal by right clicking the
affected database |Properties | Options Tab | and cleared the Restrict Access
checkbox.
That appeared to do the trick.
When I first try to change the setting I get a couple of error messages
telling me it could only have one user at a time and it was already in use. I
keep clicking OK and It then popped up the properties screen and I deselected
the restrict access. To remove the single user mode.
This only works until the following day, it returns to single mode the next
day.
I changed the single user mode back to normal by right clicking the
affected database |Properties | Options Tab | and cleared the Restrict Access
checkbox.
That appeared to do the trick.
When I first try to change the setting I get a couple of error messages
telling me it could only have one user at a time and it was already in use. I
keep clicking OK and It then popped up the properties screen and I deselected
the restrict access. To remove the single user mode.
This only works until the following day, it returns to single mode the next
day.