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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2005-07-15 : 07:47:54
|
Last night's REINDEX job failed. The job history indicates the last table being reindexed:quote:
Updating dbo.AdminAssignments [SQLS... The step failed.
DBCC CHECKDB returns no error after the fact.Any ideas what caused this error? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 08:29:11
|
| How are you doing the Reindex - just the Entperise Manager Maintenance Wizard, or some hand-crafted SProc?Kristen |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-15 : 09:26:21
|
| Some hand-crafted sProc, a derivative of one authored by a SQLTeamer. Why? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 09:34:46
|
| Just wondered whether you had a chance to put some tracking code in, or not.Suggest you run the Sproc manually, or maybe just aDBCC DBREINDEX ('MyDatabase.dbo.AdminAssignments')and see if it runs though. If not re-try with individual indexes.If the Sproc doesn't have a check for @@ERROR after the DBCC command that might be worthwhile adding (assuming nothing in SQL Logs that tells you about the error more specifically?). However, I expect an error in REINDEX would cause an Abort of the SProc, so probably nothing catchable - unless you get a bit more creative with how the REINDEX is launched - e.g. in a child SProc, or EXEC(@DynamicSQL), so that it is running, and "erroring", outside the scope of the current Sproc, and thus the error is catchable.But given all that, you'd need to have a repeatable error condition to be able to build the Try/Catch style logic against ...Kristen |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-15 : 10:12:44
|
| This might be a good time to post that any good links to maintenance procs would be appreciated... I'd like to see how others get this done. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-15 : 10:13:16
|
| BTW - I'll try to reindex that table tonight and post back then. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2005-07-15 : 13:45:35
|
| A really nice collection Tara! - Thanks for posting! |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-07-15 : 13:46:19
|
| Tnx! |
|
|
|
|
|
|
|
|
Reindex Job Step Failure