How to purge Microsoft SQL email Items
How to purge Microsoft SQL email Items There are times that housecleaning older mail in your database needs to be done. A simple scheduled task can be done every month to purge what is no longer necessary. SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove these mail history unless it is required for auditing or other purposes. As always make sure you have your backups done prior to running any sort of removal in the event you did something incorrectly. By purging you are reducing the amount of wasted space in the msdb database that could be used for other things activities. Simply running the following statement using T-SQL you can check the amount of database mails that have been processed from…