Thanks both.

After I ran the checkDB with allow data loss, there were 100 rows are missing on REQ_ITEM table.

Since it was only affected single table, I was restore from last...

Gail! Thanks for quick response.

So, can I run page level restore for this? or restore the whole DB to temp location then extract the 'REQ_ITEM' table?

Thanks again,

David.

Thanks Gail,

I guess we have to restore from the backup.

But do you know what cause this?

David.