The Multifunctioning DBA

May 28 2010   6:16PM GMT

Database Restores

Colin Smith Colin Smith Profile: 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.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: