|
Home > Archive > MS SQL Server > August 2005 > msdb Single user
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| my msdb has been put into single user mode and i cant get it back to
multi_user can anyone help me with this
| |
| Sue Hoegemeier 2005-08-30, 8:23 pm |
| What put it in single user mode? Did you check the logs?
If it was a user action, did you try executing the
following:
ALTER DATABASE msdb
SET MULTI_USER
-Sue
On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
<AB@discussions.microsoft.com> wrote:
>my msdb has been put into single user mode and i cant get it back to
>multi_user can anyone help me with this
| |
|
| I tried that but it said there was already a connection and could not alter
the database. I had to shutdown the SQL Server Agent in order to stop the
processes that are running in the background on that table. Then I could
execute the alter database statement.
"Sue Hoegemeier" wrote:
> What put it in single user mode? Did you check the logs?
> If it was a user action, did you try executing the
> following:
> ALTER DATABASE msdb
> SET MULTI_USER
>
> -Sue
>
> On Tue, 30 Aug 2005 09:17:40 -0700, "A.B."
> <AB@discussions.microsoft.com> wrote:
>
>
>
|
|
|
|
|