Take 'Backup' of SQL Server Compact database

Question

Is it possible to take Backup of SQL Server Compact database (i.e. *.sdf) and Restore the same.

Answer 1

Just copy the file. Done.

Quote from Maintaining Databases:

Because SQL Server Compact 3.5 is a file-based database system, you can accomplish many common database tasks such as backing up, restoring, and deleting a database by using the file system APIs.

To back up a database, close all connections to the database, and then copy the .sdf file. To restore a database, copy the .sdf file back to its regular working location. These operations work even if the database is set up for replication. To drop a database, delete the .sdf database file.