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..
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.