C# SQL Server Express backup and restore

Question

Basically I have a windows form C# program that uses a SQL Server Express database to store data entered by the users. I want to add the ability for the user to be able to backup their database and then load a backup or another database into the programs database.

If someone could point me in the right direction like an article or tutorial that would be great, because I have hit a dead end.

Thanks

Answer 1

You have a few options to do this:

1. On the server directly call BACKUP DATABASE, RESTORE DATABASE commands.

2. Use SMO (SQL Server Management Objects) to perform the backup restore operations programatically. (Specifically this sample)

3. Use some third party utility/library.

Answer 2

You may want to look at using this suggestion:

http://codeasp.net/articles/sql-server/118/backup-your-database-using-an-sql-command-export-to-bak