As a result of an integration with an outside CRM, we now have to do a major data cleanup/rearrangement related to Customer Ship-to entries becoming their own new Customer accounts (we were never doing this properly to begin with).
Long story short, our Controller asked if it’s possible to create a new app server with a backup of our pre-cleaned database so they can go back and look at the “way it used to be, if needed.”
We currently run SQL and 4 app servers on the same powerful VM (Live, Test, Train, Pilot). Would it be irresponsible to add this 5th app server/database? I’ve considered getting rid of either Pilot or Train, as they aren’t used. Unless Pilot is utilized for upgrades, which I wouldn’t know because we hire a consultant for those.
Any input would be much appreciated. Thank you in advance!
You got it right. Just set another app server up the same as your production one with some logical name and folks can access both at the same time. Recommendation on the legacy copy add a style with like bright colors so when they open screens they know which system they are in.
We do that for accounting with separate End of Month and End of Year environments. Get a backup at the end of the period, and restore it to the new environment.