...
1) Backup the DAM Database on Production & the destination Database (For Azure hosted servers, these are normally saved in H:\SQLBackups) this will mitigate the need to transfer/copy the backup files to the Test server using FTP later in the process.
FOR AZURE HOSTED SERVERS CREATE A SNAPSHOT AND DISK OF THE PRODUCTION STORAGE DISK, ATTACH THE NEWLY CREATED PRODUCTION STORAGE DISK TO THE TEST SERVER (this process is detailed further down this page, steps 5 & 6 are not needed for azure hosted servers)
2) Stop Digibatch, digimonitor,website + application pools
4) Delete the logfiles for Digibatch, Digimonitor and websites (Optional)
5) Copy the .bak file to the database you want to overwrite. (Only for non azure hosted servers)
6) restore the databases
6b) Check the ownership of the databases (dam and dam_jobs). It should be an SA user.
...
Rename the following folders: websites, Digimonitor and Log files to reflect the Test environment URLsURLs
Recreate the storage share and apply the relevant permissions
Rerun the Powershell installation for the current version (This will ensure all the passwords, usernames, urls and storage locations are correct
Now we are ready to commence with the database restoration process.
...