The big change is
with e-mail notification: SQL Agent no longer uses SQL Mail, but Database Mail instead.
The latter is SMTP-based, stateless, and significantly more reliable than SQL Mail ever
was. For those of you who??™ve used SQL Mail, you know exactly what I mean. For those of
you who haven??™t, you??™re lucky.
CHAPTER 5 n CREATING A BACKUP/RECOVERY PLAN 122
nTip Be wary of relying on net send as a notification method. It makes use of the Messenger service,
which many administrators have disabled by default. A bug allowed users to leverage the Messenger service
to compromise a PC. Even though the bug has been corrected, paranoia often wins over in these situations,
and the Messenger service remains disabled (I see paranoia as a good thing).
Prior to SQL Server 2005, the mail-notification method, SQL Mail, presented all
sorts of issues. It was MAPI-based, which meant it was constantly checking for new
mail. If there was some hiccup in communication between it and the MAPI-compliant
mail server, SQL Mail would cease to work, forcing you to stop and start the ???service???
(it was called a service, but was really just an extended stored procedure).
Pages:
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250