Database backup using c#

Hi can anybody know how to get the functionality of database backup and restore of a sql server2005 using asp.net 2.0 and c#..

My problem is here I'm creating an application which uses Emp file. and I'm trying to get backup of that database and again I'm trying to restore with that backup file. But here I'm getting the error message like "Database is already in use"

Is there any solution for that?

Regards,

Nagu

Hi Nagu,

Please check to see if the database is being used by some other objects, such as replications.

If that doesn't work, please show some of your restored database code. Thanks!