Spinning multiple environments from single backup file I am having a unique situation where my production database size 5TB (SQLSrv) which needs to be replicated across 4 servers daily. I am looking for an option where all 4 environments can use a single backup file as the source and continue to perform the write operation in isolation thereafter. It will save a lot of disk space and restoration time (3hours per env)
If you are open to look into 3rd party solutions, you can try SQL Clone by Redgate.
It will created virtual data files and virtual delta files. These files combined will be presented to SQL Server and it will be treated as a separate copies of the database.
You can find documentation here: https://www.red-gate.com/products/dba/sql-clone