Backing up SQL CE 4.0 during run-time

Question

When I release upgrades with my desktop app I backup my .sdf with a simple copy from the code behind.   

I do this via a background worker, and on bgw completion, I run the SQL commands to modify the DB.

Is there a more elegant way to backup 4.0?

Answer 1

No, not reallly.

---

Visit my SQL Server Compact blog - Please mark as answer, if this was it.

Answer 2

Hi Chad.Hensley,

SQL Server Compact is a file-based database system, to back up a database, close all connection to the database, and then copy the .sdf file. I suggest that you run Process Monitor to check which processes are using you database file .sdf first. You can download the tool here: http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx.

---

Best Regards,
Stephanie Lv