O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automating and Scheduling the Transfer of Your Data

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

1.
In SQL Server Management Studio, open the SQL Server Agent node in Object Explorer and select the Jobs folder.
2.
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required