MehtaY@... wrote:

> Hi All,
>
> I am using firebird 2.0. The DB was at size 35.227 MB and then shink to
> 25 MB. I found that some data is lost. Does it has any size limit?
>
> If it has any size limit, how I can backup the data before loosing.
>
> Thanks in advance for the solution.
>
> --Yogita
>
>

Yogita,

Make sure your have the attribute "Forced Writes" set to "ON" on your
database.

The limit of a FB database are relatvie to what filesystem do you use,
but neither that I aware of has such a small limit as 35MB.

I think you have forced writes off and that for any reason the database
process was not stop graciously, so you lost some data.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br