taking database back up of SQL Server 2005

Question

I have a requirement where I need to take the backup of database. Once the user clicks the button I need back up the entire database to the location

 c:/backup

Database: SQL Server 2005.

Thank you

Answer 1

You're asking for quite a bit of information in one question, but to start, you can refer to the T-SQL syntax for backing up a database:

BACKUP DATABASE MyDatabase
TO DISK = 'c:\backup.bak'

Answer 2

Look this article. You'll need to execute code analogous to this via SqlCommand:

• Create and open SqlConnection with user/pwd allowing maintenance operations on DB.

• Create SqlCommand for this connection with proper command text (see linked article).

• Call SqlCommand.ExecuteNonQuery.

Or else you may use Sql Server object model (SMO) to make a backup. See here (assemblies you need to reference are listed here).