Bob Duffy on 23 Jan 2025 13:35:59
When doing restore we always get a new database ID, Physical Name and SqlEndPoint, even if the database logical name is the same (eg restore over the top).
This causes a massive increase in RTO as afer the restore all end points broke and configuration management had to be updated and re-tested.
When doing a restore we need to have the ability to keep database exactly as it was, rather than always creating a clone.
In a recent DR event it was 5 minutes to restore, but the 2 days before we stopped getting issues on end points and config change impact.