I have some SQL Databases that are used for training.
What I have looks something like
Master Training DB
The master training DB is updated periodically with new information to include in the training. At the beginning of a training session the training DBs mirror the Master Training DB.
Currently I do a backup of the Master Training DB, and then restore over the Training DBs using overwrite.
I need assistance with a script that would automate this.
It would basically.
Backup Master Training DB to disk
Delete Training DBs
Restore Training DBs using Master Training DB Backup (Or restore with overwrite)
Your help is appreciated.