in the BPM, I noticed there is condition with that purpose:
Under the admin console, server management, there is the option “Set as Production” (we never set it… ) but this condition uses this option…
But for me I would need to Remove Production Status when I restore in my 2 other environments…it is not something to be done via a sql script I was told … so manual activity to not forget during restore process…