Maybe your Transaction log is getting full and your process is failing.

or even SSIS/data issue.

Give us more details.

Thanks but bulk logged wont work for us. Also, we are use log shipping to another datacenter.

Thanks! what i am trying to accomplish is to update the stats since they are not being kept up. I have thought about rebuilding the indexes since some...

So if we are reorganizing index nightly. is there a need to update statistics? Currently, there is no job to refresh statistics beside the database setting to update statistics....

Colin thanks for answering my question.

So we are not doing an inplace upgrade. Instead going to decluster, rebuild the node to win serv 2008 and SQL 2008 R2 and...

Thanks!

will do! 🙂

I know this is a old thread but i have a question 🙂

So if I have databases running in SQL 2000 Compatibility mode on a SQL 2005 standard server, do...

Thanks again!! 🙂 This fixed it!

Thanks Pradeep! I found and ran the script and i was able to create a Update Stats MP.

But when excuting the...

Thanks, yes! I confirmed my resource version are the same. and Also the log for the hotfix shows this:

Failed to find...

Thanks CavyPrincess. I have been reading conflicting reports on if we can even enable AWE setting on sql 2005 standard edition... Not sure if its a Enterprise ed only...

^^Yes what you suggest. Best to restore from the last backup. Looks like you will have data loss going with DBCC repair process.

Is it a RAID? Have you checked each disk's health?