I do not know much about sql server DBA tasks but my next project will be to setup a Dev, UAT environment.
Currently there is a production server.
There will be allocated one server for Dev and another server for the UAT environment.
As far as I know, I should install sql server on each of the Dev and the UAT server, then get a latest backup from production and restore to the Dev and the UAT servers.
1- Is my assumption above correct?
2- What should I consider and do to have a successful setup from start to finish for these environment?
3- Any thing you can add to this for me to learn?
4- is there a link y ou can guide me for this kind of setup for me to study before I start t his project?