Thank you so much! We'll try you're restore suggestion later, will update you after it.

Thanks 😀

we use simple recovery model for our production database

Alright, so made a wrong strategy on mirroring. Instead of restoring differential backups, can we restore logs instead? still for the purpose of mirroring.

Yes, the mirror database is used for reporting. the backup is from our production database. We want to restore to it everyday to keep it updated. When we restored...

Thanks Lynn, what we are trying to do is we execute differential backup every night, then we restore it every morning so that our mirror database is always updated. that's...