It turns out everything works fine.

We did a DBCC check on each database, there is no error.

So not sure what happened.

Thanks,