question

Kiran 1 avatar image
Kiran 1 asked

Can i do point-in-time recovery

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

sql-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeff Moden avatar image
Jeff Moden answered

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.


10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.