Tuesday, April 05, 2011 3:42 PM
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?
Tuesday, April 05, 2011 6:06 PMModeratorNo, not reallly.
Visit my SQL Server Compact blog - Please mark as answer, if this was it.
- Proposed As Answer by Imran Siddique [MSFT] Friday, September 09, 2011 6:08 AM
Tuesday, April 12, 2011 9:02 AMModeratorHi 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.