Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
what is the precautions to prevent data corruption |
Fri, Jun 13 2008 2:13 PM | Permanent Link |
Isaac | 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 |
Fri, Jun 13 2008 2:40 PM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Fri, Jun 13 2008 2:41 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Isaac
There's an SQL statement REPAIR TABLE - check it out in the manual Roy Lambert [Team Elevate] |
Fri, Jun 13 2008 2:46 PM | Permanent Link |
"Raul" | 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 |
Fri, Jun 13 2008 3:18 PM | Permanent Link |
Isaac | 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. |
Fri, Jun 13 2008 5:11 PM | Permanent Link |
"Raul" | 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. |
Fri, Jun 13 2008 5:17 PM | Permanent Link |
Isaac | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |