Donn Felker has wrote a good step-by-step article on how to access and search SQL BLOB Data from MOSS 2007. SharePoint can already search Office file formats stored in the database, this article can be used as a starting point for developing a separate database that hosts binary data readable by SharePoint. In large enterprises there is always a need to put in SLAs for various data contents, it is good practice to have a separate database containing BLOBs that could amount to significant storage space and that could be taken offline without affecting the SharePoint application critical data such as templates, sites and services meta data.
posted @ Sunday, May 06, 2007 11:48 PM