Error executing "Check Database Integrity Task" job

Question

Error executing "Check Database Integrity Task" job

ico-601891

Hall of Fame

Points: 3992
More actions
May 17, 2010 at 3:16 am

#386941

Hi all,
I receive next error in SQL Server Job History LOG when i execute a "Check Database Integrity Task" job in my maintenance plan:
"DTExec: The package execution returned DTSER_FAILURE (1)."
Also in windows event viewer i receive the next additional error message:
- EventID 12291
[ Qualifiers] 16385
Level 2
Task 0
I don't why. My SQL Server is SQL Server 2008 with SP1.
Somebody can help my?
Many thanks in advance.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Are there any errors from around that time in the SQL Server error log? CheckDB execution is logged.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ico-601891 Hall of Fame Points: 3992 More actions · Answer 2

Hi Gail,

There are only the next message: configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.'.

At the same time i have test to execute CheckDB with the account that is running my maintenance plan job. I received this error:

Msg 916, Level 14, State 1, Line 1

The server principal "MY DOMAIN0\JOBSERVICE" is not able to access the database "MYDATABASE" under the current security context.

Then i grant the sysadmin privilegies to this job account and then a can run correctly DBCheck.

But when i run Check Database Task Job i continued receiving the initial error message:

"

- EventID 12291

[ Qualifiers] 16385

Level 2

Task 0

"

Any idea how i can solve this issue?

Many thanks.

ico-601891 Hall of Fame Points: 3992 More actions · Answer 3

Hi all,

In the maintenance Plan History i can see this message:

Task Detail:

Check Database integrity on Local server connection

Databases: MyDataseName

Error number: 0

Error message: Alter failed for Server 'MySQLServer'.

Also i can execute 'DBCC MyDatabaseName' without any error.

I don't understand this comportament.

Somebody could help me?

Many thanks in advance.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Hang on, is this a SQL 2000 server? I know you said 2008, but this is something that could happen on SQL 2000, but not more recent versions.

SELECT @@version

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ico-601891 Hall of Fame Points: 3992 More actions · Answer 5

Hi,

The version is: 'Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)'.

srikantht.dev SSC-Addicted Points: 473 More actions · Answer 6

We had a similar problem. Integrity check was working fine then one day it started failing with the error mesage

"Alter failed for Server '<servername>'. "

in Maintenance Plans | View History

ran the query sp_configure against master and all the config & run values mentioned in the previous posts were 0.

Did further checking and found that when we were deselecting Processors under server properties the corresponding I/O Affinity was also deselected. This is when integrity check bagan to fail. When I checked "Automatically set I/O affinity mask for all processors", integrity check once again began to work. I did not have to reselect Processor Affinity