Thank you for your reply and for pointing out the informative articles, Ann.

I'm also following the thread on Database corruption...

-Amy

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Wednesday, March 31, 2004 4:54 PM
To: firebird-support@yahoogroups.com
Subject: Re[2]: [firebird-support] power outages


Amy, et al.

Check the IBPhoenix site for "careful write". I've written a fair amount
about the theory and practice behind InterBase/Firebird recovery. By
design, InterBase and Firebird maintain the database on-disk-structure in a
consistent state after every page write. As long as every page is win the
order that the database requests and written completely, you'll always have
a consistent database. In my twenty-odd years (some even more odd than
others) in the relational database world, I've never seen a partial page
write.

At Interbase Software Corp., we used the database for our code management
system, e-mail, bug tracking, customer/prospect tracking, financial
tracking, payroll, hr, everything. At one fairly early point in the
development of InterBase, we were in some third-rate semi-commercial
space. Power cords ran across the floor, normally duct-taped to the
carpet, but at least once a week one of us would trip over something and
cut power to a server. Add that to a power distribution system that would
do credit to a third-world country, and you can imagine that we had a great
deal of interest in seeing the database come back to life whole and happy.

Which it does, if you don't let the OS decide when to write pages.


Regards,


Ann




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]