Sorry about that guys. I appreciate your help.

Thank you very much for your time, and for the pro solution.

I now added a primary key to this table. it's identity 1,2,3,4...

Thank you very much for sharing this information.

I like this verify_only idea. it's another step in the right direction. better then nothing.

I think i'll do it.

Thanks

To restore 20gig db takes some time. do you have an idea how to test the backup quick, without wasting time?

yes, but if the backup failed, i'm stuck!!

one time the IT guy took out the wrong hot swap drive, and the db got corrupted, so if i would rollback to...

I'll check them out.

Thanks.

I would like to see transactions that cause problems, and remove them, and restore the db without them.

Thank you for the effort to help.

I can't use patindex. i want it to decide automatically which pat to search for.