To add to what others have said, at work we have 4 environments:
1. Production – this is where real world data resides and validated and approved code runs. Anything happening here has an impact on actual operations. So you can raise contracts, approve transactions etc etc here.
2. Training – a copy of production used for, you guessed, training. Code here is an exact copy of code in production. Data is updated fairly frequently. You can do whatever you want here to train yourself, has no impact on the real world.
3. Staging or testing – this is where new code/applications/features are pushed to the client to test, kind of beta testing. Again, no impact on actual real world data.
4. Development – this seats in every developer’s machine. It’s where they do their development and alpha testing.
So, yes, if someone deletes production database we’re basically f*****. But of course we have disaster recovery scenarios inbuilt into the application and recent backups. But we may lose a day of work if something were to happen to prod database.
Latest Answers