Thanks Gail. I read your article.

I tried to found type of object for some of the errors and in each case till now, one of the objects is either SP...

Thanks for the feedback.

rockymiho (10/14/2010)

---

ok that make sense.

now consider this scenario

sunday full backed up 12:01 am

sunday tlog backedup up after the full backup is completed

monday tlog backed up at 10:00 am

monday differential...

rockymiho (10/13/2010)

---

so taking the backup of the log file will truncate the log file automatically? my plan was to once in a month, when the size grows shrink the...

Thanks Wayne. I read Paul's and ur articles. There is no straight fwd way to fix this.

compatibality level for these dbs are 80 which means they were migrated right? coz...

Yes, i got positive reply from app owners but they are reluctant to do anything outside greenzone. hopefully we do it this weekend.

Besides enabling the statistics, i'll run update statistics...

the databases on QA were restored from prod in dec last year.

is there a way to quickly check if and when it was migrated? asking the primary dba will take...

in addition to what Wayne said, if possible, get these backup files moved to tape everyday having longer retention period.

i am facing corruption issues at the moment on 5 servers...

sorry, the server mentioned in my prev post is a UAT/QA box.

However, i ran checkdb on prod and getting similar errors for these two databases.

Msg 8992, Level 16, State 1,...

Thanks Gail.

I've suggested app owners abt turning on statistics settings asap for which they should be raising an RFC which will be actioned in the next available green zone. [We...

I have explained them probable consequences of this. I hope someone from the owners get hold of SAN guys to pull more information and get this fixed.

Hi Gail, We had resored this db from backups. Unfortunately we didnt find any information in event logs. Since this was a dev box, even app owners too were not...

Thanks Craig. As of now i will have to wait for the issue to re-occur to gather more information.

What i found from the error logs is sql server was...

Thanks for the articke Adi. It was helpful.

If i remember correctly, waittype column had some hexadecimal characters (5-6 characters) and lastwaittype had either PAGEIOLATCH or PAGEIOLOCK (one of these).

KB says...

backupfile table - 10k records

5 other history tables with appx 5k records each

other have few hundred records.