Database backup Fails In Maintenance Plan

[btacy]

Hi,
i have a maintenance plan set up to backup 4 databases, check the data integrity and backup the transaction log where applicable. it's been working fine for a while. I discovered today that two of the databases were not backed up. i can't seem to figure out what went wrong. Any ideas?
thanks!

 

[mrdenny]

What's in the log file for the maintenance plan?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[btacy]

in the log file, the following line is repeated for each of the databases not backed up.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database 'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[3] Database master: Check Data and Index Linkage...
[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.

The following errors were found:

[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
"The backup was not performed since data verification errors were found.

 

[mrdenny]

Looks like you've got the option to repair minor issues enabled in the maintenance plan. It's best to leave this option unchecked as it can cause this problem.

Run a DBCC CHECKDB for each database that's showing an error and see if anything is actually wrong with any of the databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[btacy]

thanks Denny,
i ran a DBCC checkdb on the databases in question. it found 0 allocation errors and 0 consistency errors.
so i'll just uncheck the option to repair minor issues as you pointed out.
i'm open to any other information on this issue.
thanks again

 

[mrdenny]

Sounds good. If the job fails in the future run the dbcc checkdb manually to see the error data.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog