[Info-vax] backups and compaction or nocompaction might be better

[Stephen Hoffman]

On 2013-01-29 15:28:54 +0000, pcoviello at gmail.com said:

> that was what I was afraid of and unfortunately I can not un-encrypt 
> the databases :-(

Copying a live database is likely futile, in any case.  Databases 
aren't fond of that, given there's no coordination with BACKUP.  
Copying an encypted database created by the database-specific 
(lowercase-backup) backup tool is usually entirely feasible, but that 
archiving processing is probably best performed with just a generic 
BACKUP command and without resorting to compression or compaction or 
encryption.

If the operation is a file-based BACKUP and you're intending to archive 
the whole disk and particularly the application-related and ancillary 
files, I'd be seriously tempted to omit the database files and related 
baggage from that BACKUP, and storing that stuff in a different saveset 
on the tape, or on a different tape.


-- 
Pure Personal Opinion | HoffmanLabs LLC