May 31, 2013 at 4:47 am
We have to refresh (restore) a number of databases at a time from our Production System to our Test Environment and I do not want to use either SSIS or the Maintencance Plan. I looked on the web for suitable scripts , but could not find any . Any ideas ? I don't want to write the restore script for either every database or have to change the backup file names manually.
Regards.
Lian
May 31, 2013 at 4:54 am
When I refresh test from production, I take approach it by first notifying everyone that I'm going to do so, then I drop the test database, then restore the test database from a production backup. This make sure everything (tables, indexes, constraints, permissions, etc.) is intact in the new test database.
I've tried a few different methods and found this one to be the best.
May 31, 2013 at 4:59 am
I am sorry for the confusion. I am actually looking for a script to do the restore of multiple databases and we only need to select only the latest backup for each database from multiple backups
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply