I was curious about how that particular problem is tackled.
1) Full backups performed on saturdays. 2) Differentials every other day. 3) Tlog backups every 15 minutes.
When trying to restore a database through SSMS: Right click on database > Restore...
It seems to hang for a long time then display the error message and display no backups to be restored and displaying the following error message:
Unable to create restore plan due to break in the LSN chain.
Looking into it, I realize that we do have all the backups but I keep 1 month of backups.
I execute sp_delete_backuphistory weekly and delete anything older than 35 days to make sure that I don't remove history for valid backups.
There are situations where the history keeps track of backups which are no longer there and we get the error.
How did you guys handle that particular problem?