> Just don’t store LOBs in the DB if DB size or LOBs access performance could t
> be an issue.
> Alexander Veremev.
I already advised caution, but that's a sweeping statement. In the real world, unfortunately, some of these archive databases can grow and grow. With the right kind of data (compresses well, seldom retrieved), there may be worthwhile benefits. For example:
* Cheaper HADR replication (logs are smaller), if needed
* Faster, smaller backups and recovery
* Leverage standard database access controls
* Leverage standard database solutions to encrypting sensitive data
I would generally not compress any LOB in a non-archiving context. By archiving, I mean writing data to a separate store where you don't (generally) expect to retrieve it again.