Restore Wizard hangs at "Retrieving backup history".
Do I need to somehow purge the history when I am performing my backups (I am using ERASEFILES = 2) on my transaction log backups so I am keeping around 9600 transaction log backups on my server at any time (200DBs * 48 hourly backup files).
For my full nightly backups I am using my own cursor to loop through and backup the databases which I don't think gives me a good place to use the ERASEFILES option so I am deleting them with a powershell script. Do I need to do something else in this step to purge the outdated history or backups I no longer have? The GUI is very useful if I need to do a one off point in time restore, but is of no value to me if it hangs, or even if it does eventually return after an hour. I need to find a way for this to become more responsive. Alternatively, does anyone have a stored procedure or script that can be used to easily generate the restore commands needed to do a point in time restore from the latest full backup plus the appropriate T-Log backups?