Hi,

I'm having issues with my db backup mp - it looks like all my system db's 
have multiple users connected..thing is this plan runs at 9:00 PM and no one 
is connected at that time...

error msg's below:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL 
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in db 'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL 
Server Driver][SQL Server]Repair statement not processed. Database needs to 
be in single user mode.

Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
Server Driver][SQL Server]Database state cannot be changed while other users 
are using the database 'distribution'...[Microsoft][ODBC SQL Server 
Driver][SQL Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL 
Server Driver][SQL Server]sp_dboption command failed. [Microsoft SQL-DMO 
(ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL 
Server]Repair statement not processed. Database needs to be in single user 
mode.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
Server Driver][SQL Server]Database state cannot be changed while other users 
are using the database 'msdb' [Microsoft][ODBC SQL Server Driver][SQL 
Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL Server 
Driver][SQL Server]sp_dboption command failed. Database needs to be in single 
user mode.

This is not a database backup error. Most likely, you have the 'Attempt to 
repair any minor problem' checked. With that option on, the maintenance plan 
may try to set the database into a single user mode. And if the database is 
being used, it will not be able to. Generally, it is not a good idea to 
enable that option.

Linchi

"Socrates" wrote:

> Hi,
> 
> I'm having issues with my db backup mp - it looks like all my system db's 
> have multiple users connected..thing is this plan runs at 9:00 PM and no one 
> is connected at that time...
> 
> error msg's below:
> 
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL 
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in db 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL 
> Server Driver][SQL Server]Repair statement not processed. Database needs to 
> be in single user mode.
> 
> Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
> Server Driver][SQL Server]Database state cannot be changed while other users 
> are using the database 'distribution'...[Microsoft][ODBC SQL Server 
> Driver][SQL Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL 
> Server Driver][SQL Server]sp_dboption command failed. [Microsoft SQL-DMO 
> (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL 
> Server]Repair statement not processed. Database needs to be in single user 
> mode.
> 
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
> Server Driver][SQL Server]Database state cannot be changed while other users 
> are using the database 'msdb' [Microsoft][ODBC SQL Server Driver][SQL 
> Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL Server 
> Driver][SQL Server]sp_dboption command failed. Database needs to be in single 
> user mode.
> 

thanks Linchi..your suggestion corrected the issue. thanks a million.

"Linchi Shea" wrote:

> This is not a database backup error. Most likely, you have the 'Attempt to 
> repair any minor problem' checked. With that option on, the maintenance plan 
> may try to set the database into a single user mode. And if the database is 
> being used, it will not be able to. Generally, it is not a good idea to 
> enable that option.
> 
> Linchi
> 
> "Socrates" wrote:
> 
> > Hi,
> > 
> > I'm having issues with my db backup mp - it looks like all my system db's 
> > have multiple users connected..thing is this plan runs at 9:00 PM and no one 
> > is connected at that time...
> > 
> > error msg's below:
> > 
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL 
> > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in db 'MASTER'.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL 
> > Server Driver][SQL Server]Repair statement not processed. Database needs to 
> > be in single user mode.
> > 
> > Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
> > Server Driver][SQL Server]Database state cannot be changed while other users 
> > are using the database 'distribution'...[Microsoft][ODBC SQL Server 
> > Driver][SQL Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL 
> > Server Driver][SQL Server]sp_dboption command failed. [Microsoft SQL-DMO 
> > (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL 
> > Server]Repair statement not processed. Database needs to be in single user 
> > mode.
> > 
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
> > Server Driver][SQL Server]Database state cannot be changed while other users 
> > are using the database 'msdb' [Microsoft][ODBC SQL Server Driver][SQL 
> > Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL Server 
> > Driver][SQL Server]sp_dboption command failed. Database needs to be in single 
> > user mode.
> > 

If that error is comming up, your database may have minor errors which
need to be repaired.  You should run DBCC CHECKDB and see what the
errors are.

Denny

On Mon, 14 Jul 2008 12:50:01 -0700, Socrates
 wrote:

>thanks Linchi..your suggestion corrected the issue. thanks a million.
>
>"Linchi Shea" wrote:
>
>> This is not a database backup error. Most likely, you have the 'Attempt to 
>> repair any minor problem' checked. With that option on, the maintenance plan 
>> may try to set the database into a single user mode. And if the database is 
>> being used, it will not be able to. Generally, it is not a good idea to 
>> enable that option.
>> 
>> Linchi
>> 
>> "Socrates" wrote:
>> 
>> > Hi,
>> > 
>> > I'm having issues with my db backup mp - it looks like all my system db's 
>> > have multiple users connected..thing is this plan runs at 9:00 PM and no one 
>> > is connected at that time...
>> > 
>> > error msg's below:
>> > 
>> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL 
>> > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in db 'MASTER'.
>> > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
>> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL 
>> > Server Driver][SQL Server]Repair statement not processed. Database needs to 
>> > be in single user mode.
>> > 
>> > Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
>> > Server Driver][SQL Server]Database state cannot be changed while other users 
>> > are using the database 'distribution'...[Microsoft][ODBC SQL Server 
>> > Driver][SQL Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL 
>> > Server Driver][SQL Server]sp_dboption command failed. [Microsoft SQL-DMO 
>> > (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL 
>> > Server]Repair statement not processed. Database needs to be in single user 
>> > mode.
>> > 
>> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL 
>> > Server Driver][SQL Server]Database state cannot be changed while other users 
>> > are using the database 'msdb' [Microsoft][ODBC SQL Server Driver][SQL 
>> > Server]ALTER DATABASE statement failed. [Microsoft][ODBC SQL Server 
>> > Driver][SQL Server]sp_dboption command failed. Database needs to be in single 
>> > user mode.
>> >