Quote Originally Posted by team_ferrari22 View Post
Is it possible to take Backup of SQL Server Compact database (i.e. *.sdf) and Restore the same?
Well...you probably have to think about SQL Server Ce in different way. All you have is the data file (*.sdf) and some libraries to access the data. You connect to the database by specifying the file. You don't have a database server in the classical sense. So the concept of backup and restoring doesn't apply. If you want to back up just make a copy of the file. When you want to restore overwrite the current file with the copy of the previous. Maybe you're looking for a way to automate this...but all you're doing is standard operations (copy, paste, move) on an file with an SDF extension.