At 09:32 AM 10/11/2003 +0100, you wrote:

>Hi
>
>We have a large datawarehouse database Firebird 1.03 running on WIN 2000
>SERVER. (NTFS)
>It is beeing filled every night from data of an old Cobol application.
>It ran smooth for cca 5 month, then we noticed the differences between Cobol
>data and data in our database.
>
>Database is beeing updated thru triggers in the following way:
>there a two tables - first collects all data from Cobol database ( date
>from - date to)
>the second is dimension table which is updated by triggers of the first
>table.
>All is done in single transaction
>
>The problems began, so it seems, when we crossed the 4G limit.
>
>Is it possible that crossing 4G limit is cousing the inconsistencies.

Yes, it is a distinct possibility. AFAIK, 4 Gb *is* the max file size on NTFS.

If you are getting "inconsistencies", I strongly recommend ****stopping****
until you have tested out the upper limit. If you inherited that NTFS
partition from NT4 (it wasn't created by Win2K) then this is indeed your
problem. Provided you haven't corrupted the database, you will be able to
take a gbak of it, and restore it to multiple files.

heLen