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

[pcoviello at gmail.com]

On Tuesday, January 29, 2013 12:47:44 PM UTC-5, Stephen Hoffman wrote:
> On 2013-01-29 16:23:26 +0000, pcoviello at gmail.com said:
> 
> 
> 
> > ok first what is endless september?
> 
> 
> 
> My bad.  http://www.eternal-september.org
> 
> 
> 
> > as far as databases we do a freeze of the application and while the dbs 
> 
> > are acquiesced we do a copy to a clone and backup the whole cloned 
> 
> > disk.  so we get all files including the cache.dat files.
> 
> 
> 
> I wouldn't bet on that approach working in all cases, particularly if 
> 
> the databases have caches, and if the database has tools to generate 
> 
> (consistent) backups.
> 
> 
> 
> 
> 
> -- 
> 
> Pure Personal Opinion | HoffmanLabs LLC

I'll check it out. not sure if I'd be allowed to use it or not, very stringent on things like that :-( 

it doesn't have caches per se but journal files so yes I would have to have them available if I had to do something during the day...

thanks everyone for your input