backup transaction log fail

'QDB Backup Maintenace'
[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 'QDB'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER
DATABASE statement failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption
command failed.
[1] Database QDB: 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.
I can do complete backup and integrity success in the plan
but the transaciton log backup and check data and index
link keep failing. Please help
Thanks
SteveIf you had not guessed/determined the problem, this error points to the =issue:
Database state cannot be changed while other users are using the =database 'QDB'
Are you using a maintenance plan to do whatever it is that you are =trying to do? Maintenance plans can help, but they are also a pain =because you have to know what each checkbox does and how all the options =work together. It has been my experience that maintenance plans do not =always work as expected. Because of this I use jobs that I create and =schedule as needed.
Are you backing up your transaction log during the day, or only at night =as part of the maintenance plan? If you are only backing it up during =the night (when avtivity is low) and not during the day (when =transaction activity is high) you are not really protecting yourself =from a failure. You should look into a "proper" backup plan ASAP!
I would recommend performing the transaction log backup(s) as often as =necessary within a separate job that you can schedule to run as often as =you want during the day.
You can then put some DBCC statements (such as CHECKDB, CHECKCATALOG, =UPDATEUSAGE) into a separate job that you can schedule for some time =when activity on the server is low.
-- Keith
"Steve C." <anonymous@.discussions.microsoft.com> wrote in message =news:22d501c44fd1$cf818e70$3501280a@.phx.gbl...
> 'QDB Backup Maintenace' > [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 'QDB'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER > DATABASE statement failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption > command failed.
> [1] Database QDB: 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.
> > I can do complete backup and integrity success in the plan > but the transaciton log backup and check data and index > link keep failing. Please help > > Thanks
> > Steve