The Databases entry now displays Specific Databases and the backup type
can be chosen by clicking on the Backup Type drop-down, as shown in the
following screenshot.
Package with Maintenance Plan Tasks
[ 294 ]
Here, a full backup of the database will be made. Notice that instead of the
database, the files can also be backed up by choosing the appropriate option.
Differential backups and Transactional log backups are also possible.
Now you need to specify the Destination. There are two choices here, the
Disk or the Tape.
8. In this example, accept the default Disk.
9. Accept the default Create a backup file for every database option.
10. Create a sub-directory MyNwind by placing a check mark in the check box,
as shown in the following screenshot.
11. Modify the Folder location using the ellipsis button to reflect the above name
of the sub-directory.
When the choices made are completed, the Back Up Database Task window
should be as shown in the following screenshot.
Chapter 20
[ 295 ]
12. Click on the View T-SQL button.
This opens the Transact SQL pop-up window generated as shown in the next
window. This is the T-SQL generated by the task. This has been a straightforward
configuration and should work the same on the SQL Server 2005.
13. Execute the task as in the previous examples by making a right-click with
your mouse on the Back Up Database Task component in the Canvas.
The task runs, and after a little while the Back Up Database component
named Backing Up MyNwnd in the Canvas turns green.
Pages:
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200