In Figure 5-2, you can see that you can rearrange multiple job stops or specify
a specific starting step. There??™s a reason for that ability, which I??™ll talk about next.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 115
Figure 5-2. SQL Agent provides you with basic workflow capabilities in that you can specify
success and failure actions for each job step.
You might be wondering why it??™s important to a backup recovery plan to be able to
rearrange the steps in a backup job. Prior to SQL Server 2005, there was no MIRROR TO
clause for the backup commands. It??™s a welcome addition, but there are still limitations.
As you??™ve seen, if you??™re backing up to a tape device, the manufacturer, make, and
model??”even the firmware version??”should be exactly the same. If you back up to a disk
device, you??™ll have more flexibility, but what if you need to have a copy of the transaction
log FTP??™d to a remote server, just in case? Having the ability to add a second job step to
copy the transaction log to a remote location after the backup has completed increases
your data protection immensely.
Pages:
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244