Sql-server – Database Mail Stop Working

database-mailsql serversql-server-2016

SQL Server 2016 Enterprise Edition SP1

Database Mail was working fine with no problem until a server patching was performed. I tried to do all the troubleshooting available but still all mails got queued and no records in the log.

Finally when I checked the database mail program I didn't find the executable file in the Binn folder or any other folders!

My questions are how this happened and how to solve it ?

Best Answer

I certainly can't explain why any Windows patching would remove executables from your Binn folder; that sounds more like the work of "security" software or manual intervention.

In any case, there are a couple of things you can try:

  • run setup and try a repair against the SQL Server installation. Maybe start with just the shared components.
  • copy the missing files from the Binn folder of another installation that works and is the exact same edition and @@VERSION. If you don't have one of these readily available, you could probably install Evaluation Edition on your workstation or a VM. But really you should have a mirrored installation somewhere that matches production so that you can test Windows patching and any other updates there first before you "try it out" in production.
Related Question