First step is to try and figure out why it happens. You should monitor errors in your event viewer for any errors that kill the web process, and try to find out error details. If your site gets lots of traffic you might want to consider migrating to SQL Server, but SQL Ce should be ok for moderate traffic.
Hope it helps,
Joe