October 27, 2008 at 11:05 pm
Please help!!!!
This is one of the logs for the failed task. There is no other info on why it fails.
If I run the following statement against those failed databases it will run fine for
a couple of days. I have checked everything, done the latest updates etc.
sp_configure 'allow updates', 0
reconfigure with override
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3073
Report was generated on "srvepsqldb01".
Maintenance Plan: Data Optimization TKCSDB
Duration: 00:44:28
Status: Warning: One or more tasks failed..
Details:
TKCSDB Rebuild Index Task (srvepsqldb01)
Task start: 2008-10-17T23:05:58.
Task end: 2008-10-17T23:29:00.
Success
TKCSDB Check Database Integrity Task (srvepsqldb01)
Check Database integrity on Local server connection
Databases: tkcsdb
Include indexes
Task start: 2008-10-17T23:46:10.
Task end: 2008-10-17T23:46:10.
Failed:(0) Alter failed for Server 'srvepsqldb01'.
TKCSDB Reorganize Index Task (srvepsqldb01)
Task start: 2008-10-17T23:30:42.
Task end: 2008-10-17T23:46:10.
Success
October 27, 2008 at 11:19 pm
The fact that this was running normally and then failde means that your database has corruption in it.
What's the output of DBCC CHECKDB (srvepsqldb01) WITH ALL_ERRORMSGS, NO_INFOMSGS?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply