SQL MP Errors - DB Backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Socrates - 14 Jul 2008 17:23 GMT

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.

Reply to this Message

Linchi Shea - 14 Jul 2008 19:40 GMT

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

> Hi,
>
[quoted text clipped - 26 lines]
> Driver][SQL Server]sp_dboption command failed. Database needs to be in single
> user mode.

Reply to this Message

Socrates - 14 Jul 2008 20:50 GMT

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

> 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
[quoted text clipped - 34 lines]
> > Driver][SQL Server]sp_dboption command failed. Database needs to be in single
> > user mode.

Reply to this Message

Denny Cherry - 15 Jul 2008 20:14 GMT

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

>thanks Linchi..your suggestion corrected the issue. thanks a million.
>
[quoted text clipped - 36 lines]
>> > Driver][SQL Server]sp_dboption command failed. Database needs to be in single
>> > user mode.

Reply to this Message