July 13, 2011 at 5:18 am
My Database Integrity job that i created through a maintenance is failing without giving a clear error message.What could be issue i created it using maintenance plan wizard.I am using sql server 2008 R2 Standard edition.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 13, 2011 at 8:00 am
Well first thing I would suggest is run checkdb manually just to make sure there is no corruption. If all is well (hope so!) open the job in SQL Agent, go to Steps, Edit, Advanced and in there is an option for an output file. That should give you more details as why it's failing. Post it back here if you need more help.
July 13, 2011 at 8:30 am
kapfundestanley (7/13/2011)
..failing without giving a clear error message.....
Please post all error information you can.
- Errorlog file of sqlserver
- MP log ( if you configured it)
even if it seem worthless, post it anyway.
Your peers may be able to figure it out. :hehe:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 13, 2011 at 8:35 am
Start by looking at the error log if you do not know the location you can check it in SSMS. Look under Management>SQL Server Logs>Current<date>
July 13, 2011 at 8:38 am
Started: 4:30:23 PM
Error: 2011-07-13 16:30:26.19
Code: 0xC002F210
Source: Check Database Integrity Execute SQL Task
Description: Executing the query "DBCC CHECKDB(N'Firstdatabase') WITH NO_INFOMSGS
" failed with the following error: "The In-row data USED page count for object "CustomersOld4", index ID 2, partition ID 575811249504256, alloc unit ID 575811249504256 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
i want to check integrity of all my user databases in this job.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 13, 2011 at 8:41 am
Then do what it says Run DBCC UPDATEUSAGE on it. Here how to use this command. http://msdn.microsoft.com/en-us/library/ms188414.aspx
July 14, 2011 at 5:50 am
I have run updateusage and the checkdb completes successfully,but my job stil cant run job.
Initially was getting this message:
SQL Server Scheduled Job 'Integrity Checks.Subplan_1' (0x3F3A67A8350F2340B4DFD5BF2E7DF56C) - Status: Failed - Invoked on: 2011-07-14 13:30:50 - Message: The job failed. The owner (WIN-69WL56MFLQH\Administrator) of job Integrity Checks.Subplan_1 does not have server access.
I recreated the maintenance plan and now i get this message
SQL Server Scheduled Job 'Database Integrity Check.Subplan_1' (0x0BDC5ACFD0A9034E868247EEC6ED3CDA) - Status: Failed - Invoked on: 2011-07-14 13:33:39 - Message: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Subplan_1).
I appreciate your assistance.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 14, 2011 at 6:18 am
What databases did you run it on? Do you know which one it failed on?
July 14, 2011 at 6:55 am
it states:
The owner (WIN-69WL56MFLQH\Administrator) of job Integrity Checks.Subplan_1 does not have server access.
Change the job owner to SA !
( this would be the only case one uses sa with sqlserver ) :doze:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 14, 2011 at 7:26 am
On the single database that i had executed the commands.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 14, 2011 at 7:32 am
I changed the user and the message is now:
SQL Server Scheduled Job 'Database Integrity Check.Subplan_1' (0x0BDC5ACFD0A9034E868247EEC6ED3CDA) - Status: Failed - Invoked on: 2011-07-14 13:33:39 - Message: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Subplan_1).
it is no longer about server access.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 14, 2011 at 7:51 am
You need to figure out which database it is failing on. If you have to run the dbcc checkdb command on every db you have manually
July 14, 2011 at 8:13 am
check your maintenance plan log output (and sqlserver errorlog)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 14, 2011 at 8:50 am
Thank you so much.I executed the job after immediately running updateusage and the job was successful.I do not know why consistent errors seem to cropping up at a faster rate.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 14, 2011 at 9:07 am
You need to figure it out... they won't stop by themselves.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply