MSDE Power Off Question

How forgiving is SQl Server MSDE in a power loss? Can it become corrupted or
possibly just loss of the last record being committed? We would like to use
it in our embedded systems that run Windows XP Embedded that allows immediate
power loss without a graceful shutdown.
Thanks for any help
Tim
SQL Server in conjunction with NTFS is very robust in a power loss
situation. The most data you could lose would be the last uncommitted
transaction, which could be one or more records depending on how your
transactions are constructed.
Jim
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:05157C9A-7065-40AE-9104-7486200CFBA6@.microsoft.com...
> How forgiving is SQl Server MSDE in a power loss? Can it become corrupted
> or
> possibly just loss of the last record being committed? We would like to
> use
> it in our embedded systems that run Windows XP Embedded that allows
> immediate
> power loss without a graceful shutdown.
> Thanks for any help
> --
> Tim
sql