Mac

The transaction log grows, grows, grows and quite often fills up.

I know two ways of shrinking it:

• With backup:

backup log netmeter(db_name) to disk=’specify the filename’

• Without backup:

backup log netmeter with truncate_only

WORM stands for Write Once, Read Many - it’s usually used for archival storage systems, and it’s actually sometimes a legal requirement (typically in SOX).

At least three solutions can be commonly found on the market:

• Centera, by EMC, is a WORM solution featuring a retention policy
• Network Appliance (NetApp) has a software solution which runs on their systems called SnapLock
• HP sells WORM Tape Drives

But there is no Open Source filesystem doing this yet AFAIK…