Re: Database files and power failures

You may want to disable write caching on your volumes. We also use MSDE on
our products and they are never being shut down properly "without having
problems with file corruptions". You can turn it off by opening a volume's
property page, go to the Hardware tab, open the hard drive(s)'s properties,
go to the policies tab and disable the write cache. Preferrably, you make a
script that enumerates all hard drives and turns the caching off, which you
schedule to run after cloning.

When you make a backup of the database, you will still need to flush the
volume...

Best regards,
Gert Leunen
Software Engineer
R&D International NV

"Davide" <Davide@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5BC89009-3133-49F9-95CA-E43765D18505@xxxxxxxxxxxxxxxx
Hi.
XPE installed on CF and SQL Express (or MSDE) installed. How minimize
database files corruption due to a power failure?
--
Davide


.

Relevant Pages

  • Re: Database files and power failures
    ... XPE installed on CF and SQL Express (or MSDE) installed. ... database files corruption due to a power failure? ... Backups are written 30 seconds later. ...
    (microsoft.public.windowsxp.embedded)
  • Exporting MSDE database from one installation to another
    ... I have two hard drives, one contains a previous installation of MSDE and a ... non-bootable OS and there is a database on that installation that I need to ... import to my new MSDE instance on the new hard drive. ...
    (microsoft.public.sqlserver.server)
  • Re: NFS and kernel cache
    ... caching writes to NFS (but I can't tell if it is the filesystem layer or ... NFS that is your bottleneck and it is related to normal buffered ... local hard drives. ...
    (Fedora)