3

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

uzay95
  • 161
  • 1
  • 5

1 Answers1

1

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.

Andomar
  • 943
  • 1
  • 10
  • 23