Issue: Why Restore database wizard/GUI for SQL Server 2014 loading old backup set to restore I am using SQL server 2014 to restore backups using the GUI, however, the back sets to restore are from old backups that are no longer available along with transaction logs that span months ago.

How can I repair the wizard so that it populates the most recent full and diffs and transaction logs like the way it used to work by default?

Here is a sample screenshot of the of the restore database screen I am making reference to
The Wizard is really just a listing of backup history records in MSDB on that local server. This wizard is not necessary to do backups. In fact, you should run a process to purge backup history on a regular basis. When I do a SQL Server Health Check for a client, I consider it a finding (relatively minor but still a finding) when this history is purged.

I am wondering if you are attempting to restore to a different server which also has that database on it?

Instead, choose Device and browse to your backup file. You'll see the right backupset to restore to inside of that backup file.

The dialog here is sort of a helper if you are restoring on the same server where your SQL Agent backups are taken but if you take backups in different ways, if you clean up history or if you are restoring to a different server, that dialog is likely not so helpful.