>> I believe that, since I've seen similar things myself. But try

pulling the plug

>> out of computer while doing that... guess which one didn't even

notice it

>> happened, and which one got database corrupted... :)

so, it is true that IB expert can lose power directly in the middle of
an insert and NOT corrupt the database.
I beleive that MSSQL would mark the database as suspect in this
situation, and a restore would probabally need to happen.
I believe MSSQL keeps track of inserts / updates ect through a flag and
if this flag is set to the wrong value when the database server is
restarted then the database is marked as suspect.
However a UPS can greatly help in this situation, again I guess this
comes down to money :)

cheers

martin.




--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org



_____

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/> .



=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server


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