Posted by: Colin Smith
DBA, Powershell, Recovery
In my environment we have a few instances where the customer would like to have a refresh done from Production to a test server. This is good for me since it gives me a chance to test my backups and make sure that they are good. It is good for the developers because then they are working witht the current data set. Unfortunatley, it is not good for them to always have a full copy of current production data on that system, so I can not do replication or even better log shipping. I have to manually restore a backup of production to the test instance. This is not a big deal but it is sometimes time consuming. I am working on a PowerShell script to automate this process for me. Should be pretty easy to do and I will post what I come up with.