Database becomes corrupted at least 1x per month

Thread View: borland.public.interbase.linux

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Edilmar Alves Wed, 25 Oct 2000 00:00

#12

Author: Edilmar Alves
Date: Wed, 25 Oct 2000 00:00

13 lines
971 bytes

Hi,

I have a database into Interbase 5.1.1, with these properties:
- Database size: 45888 Mb
- Sweep Interval: 20000
- Enable Force Writes: no
- Allocated DB pages: 45237
- Page Size: 1024

Then, at least 1x per month, I need to do a Backup and a
Restore to reconnect to the database. What's the problem ?
I'm worried about some day that this Backup/Restore won't
work more, and I will lose the database !

Re: Database becomes corrupted at least 1x per month

#13

Author: Dan Palley
Date: Wed, 25 Oct 2000 00:00

22 lines
1213 bytes

- Turn off your sweep interval (there's a sweep bug in 5.x versions prior to
5.6)
- Upgrade to 5.6 (free).

Dan

"Edilmar Alves" <edilmar@intersite.com.br> wrote in message
news:39F6BE01.1777A97A@intersite.com.br...
> Hi,
>
> I have a database into Interbase 5.1.1, with these properties:
> - Database size: 45888 Mb
> - Sweep Interval: 20000
> - Enable Force Writes: no
> - Allocated DB pages: 45237
> - Page Size: 1024
>
> Then, at least 1x per month, I need to do a Backup and a
> Restore to reconnect to the database. What's the problem ?
> I'm worried about some day that this Backup/Restore won't
> work more, and I will lose the database !
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads