These same tasks will be carried
out by SSIS, except that the task is saved by default to the file system. The default
where these are stored starting from the wizard will be on the SQL Server. These
tasks on the SQL Server are not automatically visible nor can they be invoked in SSIS.
??? ??? ???
Package with Maintenance Plan Tasks
[ 288 ]
The Maintenance Plan Tasks group in SSIS has the same tasks you find in the above
wizard (as shown in the next screenshot) except that you have an additional task, the
Notify Operator Task. Notifying the operator in the Management Studio is carried
out by the SQL Server Agent through the Alerts node.
Chapter 20
[ 289 ]
Backing Up a Database
Data loss to business is unacceptable. A copy of the most recent data should always
be available. A backup copy of data is therefore indispensable for restoring the
database, if for some reason the production data becomes unavailable due to media
problems, hardware failures, etc. While backup activity is always paired with restore
activity, SSIS has only the backup task. The backup activity requires a lot of planning
as to how frequently the data has to be backed-up, what is to be backed-up, data
or data files; what type of media will be used for keeping the backup, what type of
backup is needed, etc. The Back Up Database Task takes these into consideration, as
will be seen in the hands-on exercise.
In this chapter, we will just consider one of the options available in the Back Up
Database Task.
Pages:
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200