Now that we've created LIVE, it's time to create all our other environments from it. This is best done once the installation checklist has been completed in LIVE and following these basic steps:
Start by shutting down all the LIVE AOS servers. Some information is held in memory on the AOS servers, and is only written to the database once the AOS is shutdown.
Perform a full backup of the LIVE databases, the transactional and baseline DB (and in 2012 R2, the application DB), then restore it using the Restore File and File Groups option in SQL Management Studio. This will give you the option to specify a new database name and will ensure the files are created correctly. You can restore the same backup multiple times to create your environments.
Remember to stick to the naming convention, for example, CTO_DAX6_PRELIVE, CTO_DAX6_TEST, and CTO_DAX6_DEV.
The same procedure can be used for copying the LIVE database over the other environments on...