write a PS(WAPS)
1)WAPS to take backup of following databases
SQL Server name is atl123
Databases should be stored in C:\DB\Backup\
Q) How a database needs to be stored?
A)Should be stored with data convention like for DHIH it will be DHIH.currentdate.bak
2) WAPS to drop above databases on sql server atl123
3)WAPS to restore the database
Here you will find many databases in the folder with date convention.
You need to script in such a way that it picks the latest from date from the folder and restores.
Ex:In the folder you may have
Script it in such a way that it selects latest ie DHIH.6.24.2016.bak to restore
Same for TAKE and SSIS DB also
And also make sure when selected DHIH.currentdate(Ex:DHIH.06.24.2016),,,,It restores on the server as "DHIH" only