March 11, 2011 at 6:55 am
One of our developer wrote a trigger that sends out email as an alert of certain concern.
Currently we don't have Database Mail enabled. I would like to hear if there are any disadvantages with enabling Database Mail. Does it mean we have to enable Service Broker too?
Can Database Mail be configured to route email to our email server so that emails and attachments do not have to be saved in MSDB? I would rather have our email server responsible for queuing and sending email instead of the database server.
How about the use of SSIS package? I know it is capable of setting up a email server in the package. I am leaning towards not having the Database server act as an email server too. Thanks very much.
March 11, 2011 at 7:02 am
No, you don't have to enable Service Broker (although you're correct that it uses it). It works regardless of the Service Broker option.
My experience with Database Mail is that it's well written and light-weight. Unless you're going to start hammering out thousands of emails, I'd say it's not something to worry too much about.
March 11, 2011 at 7:16 am
Database Mail is a new feature introduced from SQL Server 2005 onwards and I would have no qualms using it.
M&M
March 11, 2011 at 7:37 am
Database Mail isn't a mail server. It has to route through Exchange or some other mail server to get to your inbox. The data is only stored in msdb long enough to get it to some SMTP server.
March 11, 2011 at 8:40 am
it (sqlserver) keeps records for all mails it sends.
This is something you need to take into account.
We have dbmail enabled on all our sql2005 and > instances to monitor for certain events that aren't captured by our monitoring software.
See the script I attached for more details of the sqlagent job that deletes dbmail archive data.
Modify the frequency and retention parameter if needed.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 11, 2011 at 3:57 pm
Thank you so much for the responses. Sounds like people who uses Database Mail have no complains. Plus it is good to know it uses an actual email server to queue and send out email which is good.
Thanks for the attached scripts, I will look at it this weekend. I guess I will go with enabling Database Mail. Thanks again for all the responses, that help eases my earlier worries. You all have a good weekend.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply