I have a database from which all tables got deleted by accident. Unfortunately we do not have a 'perfect' backup and now my problem comes in:
- FULL Backup is from yesterday, 18:00
- LOG Backup wasn't taken for several days. That backup was performed manually after the delete.
- Both files are available to me to perform a point-in-time restore
To restore point-in-time, i restored the FULL-Backup WITH NORECOVERY. Then i tried to apply the Log-Backup. After it reaches 100% in GUI, i get the following error:
LSN-Information of FULL-Backup:
Am i right that the overlapping LSNs of FULL and LOG-Backup are the problem here? I think it is not accidential that
PrevPageLSN from the error matches the
FirstLSN of the FULL backup. Ideas how to get the database restored point-in-time?