SSIS and backup/restores
Posted on 2011-02-28
Server1 has the database.
It has to restored to Server2 everyday at a particular time.
I can run a command from Server1 to backup to the shared folder that Server 2 also has access to. Then I can run a command from Server to restore to the database name desired.
With plain t-sql job, i am not seeing a way to do this in one process/job. With SSIS, can i accomplish the above in one sitting.?