On Thu, May 19, 2011 at 12:23 PM, len.lewin <len.lewin@...> wrote:

> I have been tasked with reducing the size of our database. I have extracted each blob, compressed it, and put it back in the database. The size of the database has not been reduced. From what I understand, the database will now use this un-allocated space for future record and blob additions. Is this correct?

Yes.

>
> From reading other posts, I could possibly zip the database, restore it and this will reduce the size by removing un-allocated space. Is there another method to reduce the database size after the blob data has been compressed?

Zipping/unzipping the file won't reduce the database size. Backing it
up and restoring it with gbak will almost certainly result in a
smaller database. Gbak is essentially a database dump and reload. It
creates a new database file, stores the data table by table, and
recreates the indexes.

Good luck,

Ann