June 16, 2003 at 2:16 am
I have recently started to run a maintainance plan one of the major databases on an SQL2K server. The plan fails with the error message "[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode." - I have encountered this message before on another database. Does anyone know of a simple solution rather than my previous one which was to run a SQL script to place the database in Single User mode before the plan executes
June 16, 2003 at 4:22 am
Nope. You have to get everyone disconnected. A shame they don't offer the option. For example, if you have replication running, you have to stop the log reader.
Rather than worry about it, I leave the box unchecked. You might see an error once a year, when it happens, you can handle the single user thing manually.
Andy
June 16, 2003 at 5:58 am
Thanks Andy - I have looked over all the jobs running on the server to see if any one of them would interfere with the maintainance plan. I cannot find any job which does.....excluding the plan itself. Is there any other possible reason for this error or should I look again ?
Edited by - Mad_Eddie on 06/16/2003 05:59:43 AM
June 17, 2003 at 10:35 am
Does your maintenance plan run a dbcc checkdb or checktable? It sounds like it is running one of those process with a parameter such as repair_rebuild, repair_allow_data_loss or repair_fast. In order to run these process', the database must be in single user mode.
June 17, 2003 at 1:10 pm
check this KB Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;290622
June 19, 2003 at 5:08 pm
If you create maintenance plan from EM, you might selected integrity check, then selected include indexes and attempt to repair any minor problems. Repairing need database in sigle user mode. You needn't select repair for daily maintenance plan.
Robert
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply