You can automate your data transfer using SQL Server Agent and SSIS. You can use Agent alone to schedule the various data movement techniques described above. SSIS can be used as well to graphically link various tasks and take advantage of the workflow engine that is built into it. In this section, we will walk through setting up a step for a backup procedure and then scheduling it.
Scheduling a Backup Operation Using SQL Server Agent
In SQL Server Management Studio, open the SQL Server Agent node in Object Explorer and select the Jobs folder.
Right-click the Jobs folder and select New Job from the context menu to open the New Job dialog box, shown below. This dialog box, like many SQL ...