I found the following error in my maintenance plan please help me on this
Under maintenace plan history i found this error:-
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
and jobs failed with following error
i found this error in job history of optimization & integrity check jobs:-
Executed as user: XXXX\admin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
Please help me find out the solution
Thanks in advance
Regards,
Sumitdo not use maintenance plans. setup your own jobs for this stuff. easier to troubleshoot and you have more granular control.|||This error isn't caused by the maintenance plan, but rather occurs within the job the maintenance plan creates. The error is generated by UPDATE STATISTICS, and in my experience is related to attempts to update the stats on a table that is used to record or maintain table statistics (such as a table within the msdb database). Unfortunately, I have not been able to reliably reproduce the problem in order to debug it. When I run UPDATE STATS on the offending table a second time, it always completes succesfully. So far, it has not bothered my enough to make me want to delve into it any deeper.
Wednesday, March 7, 2012
Integrity check and optimization job failed
Labels:
database,
error,
error-microsoft,
failed,
following,
history,
integrity,
job,
maintenace,
maintenance,
microsoft,
mysql,
odbc,
optimization,
oracle,
plan,
server,
sql,
sql-dmo,
thisunder
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment