Microsoft SQL Server 2014
I need to setup a automated weekly schedule that copies one database to another after hours. One is the main database and the other is a training database.
I have been trying to set this up in SQL Server Agent - Jobs. But can not Google the right info.
If anyone can please advise the best way to do this.