our application uses the SQL server 2008 compact edition and entity framework.
The application will control the instrument. It may run for several days before it stops.
In order to protect the database crash (database failure), we plan to backup SQL compact database during running.
Can we backup or duplicate the ~.sdf when application is running?
Is there any SQL server command we can call inside the application to achive the backup?
Or we only can backup the database when application is not running.
View Complete Post