I have taken full backup on Sunday. I have taken 2 differential backups on Monday and Tuesday. On Thursday, somebody deleted the full backup on sunday. Can i do point-in-time recovery
No. 2 reasons.
First, to start the restore you need a 'base'. Log and differential backups are incremental to that base. You need a full backup to give you that base.
Second, even if you had a full backup, you cannot use a diff to give you point-in-time recovery - you need log backups for that.
I'll also state that if you're in the FULL Recovery Model or changed that to the BULK LOGGED Recovery Model, your log file may blow up any day now from consuming all of the hard drive space available to it.Either way, it sounds like you need to revamp your backup plan with the understanding that backup plans aren't the end game... you actually need a restore plan, which will dictate what your backup plan needs to be.
If you want to be able to do PIT restores, then you really need to be in a Recovery Model that supports log file backups. I strongly suggest that you read the documentation on the subject and learn what terms like RPO and RTO mean and why they're important.
18 People are following this question.