Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-08-29 : 15:47:07
|
| Hi, This is the first time our db integrity job failed. I am looking at the error log and there is no trace of it!We applied SP3a a week ago. I don't think it is related to it but I don't know what went wrong as there is nothing written to log about the failure of this job!Where do I start?Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-29 : 15:56:00
|
| Run DBCC CHECKDB(DBNameGoesHere) in Query Analyzer to see if the database is corrupt. If it doesn't report any errors, then the problem is with the job. Just recreate the maintenance plan and job if the database is fine. Then kick off the job. If it still fails, check the owner of the job. Does job history say anything? Or just maint.exe failed? There are several people here who would not use maintenance plans. The integrity check job just runs the DBCC command from above, so you don't need to set it up through the wizard.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-29 : 15:57:52
|
| I should have mentioned that if the DBCC command does report errors, then you've got a corrupt database. Check BOL for the two repair options for the DBCC command. If those do not work, then there are a few options to fix the problem. Let us know if your database is corrupt and we'll help you through it.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-29 : 17:06:43
|
| What does the integrity job do? I would advise not using sqlmaint.exe for this sort of thing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-29 : 17:10:03
|
| The integrity job runs DBCC CHECKDB. The optimizations job can run DBCC DBREINDEX, UPDATE STATISTICS, and DBCC SHRINKDB. Typically, only DBCC DBREINDEX is run though.Tara |
|
|
|
|
|
|
Database Integrity Job