At 10:26 AM 21/06/2005 +0800, you wrote:

>Dear All,
>
>This problem might not related to firebird at all but the backups are.
>When ever I tried to ftp my 7GB of backup from linux to windows I get
>this error:-
>
> erp_sd-2106.fbk:No space left on device426 Failure writing network
>stream.ftp: 4294926120 bytes received in 448.47Seconds
>9576.86Kbytes/sec.ftp
>
>
>I've already tried to download using scp and http and been getting the
>same sort of error "No space left". The thing is the windows machine
>still got plenty of space for this file. The windows that I've tested
>are Win 2000 and Win XP . If I'm downloading this to another linux
>machine, I don't get this problem.
>
>The windows machices hd space left > 20 GB

It looks as though you are trying to copy the file to a FAT or FAT32
partition. FAT has a file size limit of 2 Gb; FAT32 on Win2K or XP has a
4 Gb limit. You'll need to copy it to an NTFS 5.0 partition; similarly,
when you restore the backup, it must be to an NTFS partition that has
enough space for the recreated database file. (An NTFS partition that
existed when an NT4 system was upgraded to Win2K or XP will not do, either,
because NTFS 4 also limits file size to 4 Gb).

If you don't have any NTFS 5 partitions available, you can take a fresh
backup on your Linux (presumably ext3) system, backing up to multiple
files. Similarly, when you restore on the FAT partition, you can restore
the database as multiple files of suitable sizes. Once your backups and
database files are split into multiple files, make sure you keep them
together when you move backups and databases around.

./heLen