There is a production db in SQL Server. We still have development on this database and I want to create it's copy in every X day/week/month. Is there any job or something else what can make this on SQL Server?
Thanks in advance..
migrated from stackoverflow.com Nov 22 '11 at 9:28
This question came from our site for professional and enthusiast programmers.
Assuming you have backups, you could call RESTORE on the development database. You can do that from a SQL Agent job, or a scheduled task like a powershell script.
The restore wizard itself allows you to script a restore action, which can help to write out the full RESTORE statement.