Den 2012-01-01 23:47 skrev Lester Caine såhär: > Dimitry Sibiryakov wrote: >> 01.01.2012 21:31, Kjell Rilbe wrote: >>>> So far, these are the suggestions I've seen >> Hey, how about my suggestion leave everything as is and perform >> backup-restore cycle on >> demand?.. >> >> Pros: >> - No overhead. >> - No additional disk space. >> - No code change. >> Cons: >> - DBA with brain is required. > ... Requires a downtime? Which can be substantial > Unless the configuration can be set up to allow updates applied following the > backup-restore cycle to be reapplied?
Interesting proposition in its own right. :-) I'm thinking that nbackup does something along those lines, but on the page level. Would it be very difficult to implement something similar but on the record level? Avoiding downtime during backup/restore might be a more common requirement than the 64 bit txn id issue. Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
