V-79-57344-65085 - There was a problem running the DBCC. DBCC failed because the following SET options have incorrect settings: 'ARITHABORT'
Hi all,
I'm getting that error message that cause my backup job to fail.
I read 10 times the mentioned document (http://support.veritas.com/docs/278799) but I don't understand how to solve the problem...
I asked to my database admin to check the status of the option (ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and ANSI_WARNINGS must be set to ON. NUMERIC_ROUNDABORT must be set to OFF. ) and everythings seems ok, but the DBCC still fails and consequently all my backup exec 12.5 job.
At this point i tryied to configure the DBCC using a sql agent job as described in the symantec document, manually launch the process but i get the same error.
After 3 days of digging into the problem i found another doc from Microsoft (KB902388). It tells me to add this parameter -SupportComputedColumn at the end of the TSQL dbcc command and finally it works with no error.
At this point what can i do to solve my backup problem???
I cannot add the parameter in the backupexec job (or I don't know how i can add it...).
Thank to anyone who can help me...
Set arithabort on and then
Set arithabort on and then try the backup. That is one of your options. Or you may decide running backup without DBCC, but that may have an impact on consistency of your backup sets. DBCC is a way by which Backup Exec identifies whether the database is consistent at the time of backup. But, this is an optional thing, you may disable it from the backup job properties. But, the permanent fix would be to leave arithabort on before dbcc check.
Please mark it a solution, if this is useful.
Thanks
But I have already set the
But I have already set the arithabort on!
I executed the DBCC useroptions and the arithabort is ON (and also the other options specified in the Symantec doc.)
I don't want to remove the DBCC option in my backup job, I want to fix the issue but by now seems that the arithabort option it's not the cause...
I'm sorry for my poor english, I hope you can understand...
If you run this dbcc command
If you run this dbcc command on the SQL server, through query analyzer, do you get same errors? If yes, i would suggest you to get support from Microsoft for this error message. The fix that is mentioned in the KB, you mentioned, does that fix the dbcc command run out of Backup Exec? There is no option within Backup Exec, which can help you change the default behaviour of the DBCC command.
Thanks
Scheduling a sql agent job
Scheduling a sql agent job with this command
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 34AE7B26-F4BA-4C3A-B432-EA92B58F5861 -WriteHistory -CkDB '
ends with the same error reported by backup exec, but i find adding this parameter -SupportComputedColumn let the job to complete succesfully.
So, How can i pass that parameter to backup exec job???
Well, you really cannot pass
Well, you really cannot pass that parameter to Backup Exec when it performs the consistency check. You may need to speak to Microsoft to get this consistency check work without the switch. Alternatively, you may exclude the consistency check from the job, but run consistency check using a pre-command in the Backup job properties.
Thanks
Ok, thanks. This weekend i'm
Ok, thanks.
This weekend i'm going to try another workaround.
If it will works i'll tell you.
Would you like to reply?
Login or Register to post your comment.