Re: [firebird-support] gfix -v -full sufficient?
Den 2020-01-11 kl. 15:05, skrev Ann Harrison aharri...@ibphoenix.com [firebird-support]: > > > On Jan 11, 2020, at 7:37 AM, Kjell Rilbe > kjell.ri...@marknadsinformation.se [firebird-support] > wrote: > > > > Does gfix -v -full detect all kinds of database corruption? Or are > there > > corruptions that cannot be detected > > Gfix finds only errors in the physical structure of the database. > These include problems like doubly allocated or unallocated pages, bad > back version pointers, and orphaned back version chains. > > Gfix will not find logical data errors like duplicates in a unique > constraint or broken foreign key relationships. > Understood. But I take it then, that gfix -f -full does detect ALL kinds of errors in the physical database structure? A gbak backup + restore cycle should find logical errors, I assume. But a restore with the -inactive switch wouldn't find any violations of constraints that are based on underlying indices, right? I.e. it wouldn't detect duplicates in unique constraints or primary key violations? Regards, Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] gfix -v -full sufficient?
> On Jan 11, 2020, at 7:37 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > Does gfix -v -full detect all kinds of database corruption? Or are there > corruptions that cannot be detected Gfix finds only errors in the physical structure of the database. These include problems like doubly allocated or unallocated pages, bad back version pointers, and orphaned back version chains. Gfix will not find logical data errors like duplicates in a unique constraint or broken foreign key relationships. Cheers, Ann >
[firebird-support] gfix -v -full sufficient?
Hi, Does gfix -v -full detect all kinds of database corruption? Or are there corruptions that cannot be detected that way? I haven't seen any indications of anything wrong, I'm just trying to check as best I can after a migration. I have already tested a full gbak backup successfully, and will also try a restore from that backup. Mvh, Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] Safe to clean out C:\ProgramData\firebird folder when FB offline?
11.01.2020 08:23, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Is it safe to clean out the contents of the C:\ProgramData\firebird > folder, i.e. wipe it, when the Firebird service (superserver) is not > running? Yes. Only temporary files are there. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/