• thanks for the prompt reply. But lets say example, i do a full backup on monday and a differential backup daily and transaction log daily for every 5 mins.

    If i need to restore database on friday at 12pm. I have to restore the full backup on monday, follow by all the differential backups from monday to thursday and then from restore all the transaction logs from monday until friday 12pm? Is that correct?

    It would takes hell lots of time trying to recover, am i right? thanks