I am trying to automate my code by restoring once a week database from one server to another, this is my plan:
1.Create back up,
2.copy back up from one server to another
3.restore backup to the server.
How can I do it,can any one recomend it any expereince with it?