May 28 2010 6:16PM GMT
Posted by: Colin Smith
DBA, Powershell, Recovery
Database Restores
Posted by: Colin Smith
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.




