In our production environment we have a large database (
SQL Managed Instance), roughly around 400-500 GB. We create a copy of this database and use it to restore in our development environment to create a database (
SQL Server 2019) our developers can use. We create a backup of out production database every day, however the restore processor takes a very long time and therefore don't often restore the development database.
With our growing development team we are noticing that we are stepping on each others toes and causing delays. We are looking into creating a single database per developer, as well as updating the frequency in which we restore these databases.
I am writing this to get some advice on how to approach this task. Please let me know if you require more information.