The 2005 version of SQL Agent includes even more functionality.
I??™ll digress a bit and focus on SQL Agent itself. This may seem out of place in a book
focused on disaster recovery, but the SQL Agent service executes most automated activities,
so it??™s important to be aware of the new benefits that the 2005 version brings, as well
as potential pitfalls.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 113
Job Schedules
In SQL Server 2005, the GUI no longer displays a button for creating a schedule when
creating a backup. That doesn??™t mean you can??™t schedule the backup through the GUI,
though. The ubiquitous Script button at the top left of every screen in Management
Studio includes a ???Script to Job??? option.
One of the more infuriating aspects of previous versions of SQL Server was that
whenever you created a schedule for a SQL Agent job, a new row was created in
sysjobschedules, even if the schedule was identical to a previously created one. Constantly
re-creating the same schedule caused needless work and increased the possibility
of human error. I??™ve even run into some situations where clients give schedules
names such as ???M-F 4am??? rather than more useful and descriptive names such as
???Daily Backup.
Pages:
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242