Question

Storage of Exchange client

4

In our project we use the exchange client to communicate with an exchange 2007 environment. The project works with a microsoft sql 2008 database. When using exchange client the database growth cannot be justified by data growth. It appears that when deleting records form the database the related BLOB's (Binary Large Objects) are not deleted. Does anyone know how the related BLOB's can be deleted as well?

asked 2010-09-20

Tim Broeke

2 answers

Sebastiaan van den Broek · Answer 1 · 2010-09-20

I'm not sure what you're referring to by these Binary Large Objects. The content of inline images such as in signatures is stored in the ExchangeClient module in the body field of the entity called GenericObject. This is saved in base64 format as a part of the body HTML so the html viewer widget can display the full email (or task/calendar item/etc) easily. There are no other types of binary/etc objects in the database itself. Actual attachments are saved on the hard disk and are only referred to in the database.

Jonathan Veldhuizen · Answer 2 · 2010-09-21

I think you mean CLOB's, because all e-mail items in the database are stored as (long) text.

Shrinking a database is possible when there is a full backup (also a backup of the transaction log) of the database. When this is the case, right-click your database (in Microsoft SQL Server Management Studio), choose Tasks, Shrink, Database. In the upcoming window, you can shrink the database, which will reduce the size of the database if it's possible.