Backup is not showing all backups in Restore wizard
I desperately need of your help for restoring the database, i cannâ€™t Restore database by using Red-gate software, before going ahead i would like to tell you how my backup plan works.
I have setup full backup very Sunday night(deleting old file older than 8 days), Differential backup everyday night along with truncate log file(deleting old fileâ€™s older than 7 days) , and the again log file backup that run after each 30mint gap(deleting old files older then 2 days).
The problem with me is that i want to restore the database to my pervious last T-log backup, but now when i try to restore itâ€™s just showing the only file to restore that has been run last time and more over my full backup run on 19th septemember and on 20th septemeber, but in wizard it's only showing me backup of 19th not the one of 20th,, i check the files in backup folder , the files exist over there but in restore wizard itâ€™s not showing those file. so it's mean it's showing me only 1 full backup file option of older date and only T-log backup file that been created last time,
Please do help me considering this urgent
DBA - LDSI