Hi,

i use Firebird 1.5.3 and i am happy.

i deploy my programs a lot of customers and different locations. i recommend
using UPS for electric problems and they use too. But sometimes there are
some electrical problems and windows crashed and database corrupted. But
sometimes db corrupted when electric ok. i usually see "*internal gds
software consistency check ... *" error.

i have some questions and i want advise.

1. i use Remote Desktop connection for some administrative tools. XP has 2
connection limits for RDC. This server has 3 clients. i see in firebird log
"*Shutting down the Firebird service with 2 active connection(s) to 1
database(s) *" error. and in NT event log these errors :

*"The Firebird Server - DefaultInstance service was successfully sent a Stop
control.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.",

"The description for Event ID ( 261 ) in Source (
FirebirdGuardianDefaultInstance ) cannot be found. The local computer may
not have the necessary registry information or message DLL files to display
messages from a remote computer. You may be able to use the /AUXSOURCE= flag
to retrieve this description; see Help and Support for details. The
following information is part of the event: Server Shutdown: C:\Program
Files\Firebird\Firebird_1_5\bin\fbserver.exe: normal shutdown 384
402653184 s and supply the2"*

Remote Desktop Connection could cause any corruption or close service for
database?

2. i see sometimes in firebird.log deadlock error. is this cause any
corruption for database. error like this : "lock conflict on no wait
transaction
deadlock ..."

3. i use Delphi 6. Some project use IBX components and one project use BDE
for connection firebird. anything related with this?

4. i use generally Firebird 1.5.3. Update 1.5.4 could help with this?

5. Clients use generally Windows XP SP2. i close system restore future.
anything related XP or antivirus could cause corruption?

6. while Firebird Service open Copying database file (Windows copy-paste)
could cause corruptions? i warn my customer didn't do with live copy when
service open but maybe they do this sometimes.

7. Some of my foreign keys is rarely used. For example if there is about
60.000 records only 70 or 80 records has a value, the others is null. i read
this type foreign keys isn't recommended. This type database design faults
could cause corruptions?

These happen very rare but a lot of time waste for me. it tooks nearly a
work day for me and i couldn't detect reasons. How could i detect exact
reasons for corruptions?

PS. sorry my English.

Best Regards.


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