Hello,
- some database affected by windows system restore and anti-virus ,
etc... please advice what is the best way to protect data (other than
backup of course)

- In case data is corrupted how I can fix the database ? is there any
special tool for that ?

Thanks

Isaac,

> etc... please advice what is the best way to protect data (other than
> backup of course)
Protect against what?
In general, you protect your data by using reliable hardware, properly
setting the access permissions and regularly backup data, of course.
I know this is trivial, but you need to be more specific about what your
fears are

> - In case data is corrupted how I can fix the database ? is there any
> special tool for that ?

You can use "Repair Table" under "Tasks" in EDB Manager or you can use
SQL from any app:

REPAIR TABLE <TableName>

Note however that depending on the type and extension of damage in your
tables, there is no guarantee that the tables can be repaired.

--
Fernando Dias
[Team Elevate]

Isaac


There's an SQL statement REPAIR TABLE - check it out in the manual

Roy Lambert [Team Elevate]

You should always have a current backup not stored on same computer - after
all your hard drive might die  And you can automate this with a job.

AV : exclude all EDB config and data tables from AV scan. This applies to
pretty much any DB engine out there (especially with AV real-time scan) .

System restore : should not affect EDB since its file extensions are not
monitored by system restore.

Fernando covered the repair options in another email

Raul


"Isaac" <no@no.com> wrote in message
news:CD6B666F-555C-4A93-9A7A-E3D28FD63B83@news.elevatesoft.com...
> Hello,
> - some database affected by windows system restore and anti-virus , etc...
> please advice what is the best way to protect data (other than backup of
> course)
>
> - In case data is corrupted how I can fix the database ? is there any
> special tool for that ?
>
> Thanks

Isaac wrote:
> Hello,
> - some database affected by windows system restore and anti-virus ,
> etc... please advice what is the best way to protect data (other than
> backup of course)
>
> - In case data is corrupted how I can fix the database ? is there any
> special tool for that ?
>
> Thanks
Ok and I liked the scheduled backup system - but what about power
failure is there any case recorded from that ?, I need to know if there
is something common that can corrupted the database.

to Fernando:
my fears is as I said from other software like anti-virus and windows OS
as it is not stable OS.

Isaac,

You need to be little more specific on what you're looking for : there has
been some good advice given in the thread, based on on your questions.

Specifically for power - get a UPS and auto-shutdown software. it's dirt
cheap. For AV: exclude EDB data files.

DBISAM and EDB have generally proven to be quite reliable and search of the
newsgroup shows that lot of the issues have been HW or network problems to
begin with.

You need to look at your application behaviour - what is your
reading/writing ratio, review multi-table transaction, etc?  Are you doing
many large writes - application or OS crashing in the middle of it might
cause all kinds of issues (applies to all DB systems).

Look at C/S and replication (of data and backups) to move data to
centralized (and hopefully) better HW . It's really up to you to assess the
application, environment and risk - you can make EDB very reliable with all
of the features it has now but it will take some work from you (and $$$ and
complexity to set it all up)..

Finally, there is nothing inherently unstable about Windows - you just have
to get good quaility HW and set it up and maintain properly.

Raul



> to Fernando:
> my fears is as I said from other software like anti-virus and windows OS
> as it is not stable OS.

Raul wrote:
> Isaac,
>
> You need to be little more specific on what you're looking for : there has
> been some good advice given in the thread, based on on your questions.
>
> Specifically for power - get a UPS and auto-shutdown software. it's dirt
> cheap. For AV: exclude EDB data files.
>
> DBISAM and EDB have generally proven to be quite reliable and search of the
> newsgroup shows that lot of the issues have been HW or network problems to
> begin with.
>
> You need to look at your application behaviour - what is your
> reading/writing ratio, review multi-table transaction, etc?  Are you doing
> many large writes - application or OS crashing in the middle of it might
> cause all kinds of issues (applies to all DB systems).
>
> Look at C/S and replication (of data and backups) to move data to
> centralized (and hopefully) better HW . It's really up to you to assess the
> application, environment and risk - you can make EDB very reliable with all
> of the features it has now but it will take some work from you (and $$$ and
> complexity to set it all up)..
>
> Finally, there is nothing inherently unstable about Windows - you just have
> to get good quaility HW and set it up and maintain properly.
>
> Raul
>


I already have a ups but customers most of them are not so I am asking
about this.

thanks