0

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

2 Answers 2

2

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'
0

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).

1
  • THIS GIVES ME TAKING BACK UP FROM SQLSERVER . I NEED TO ACHIVE THIS FUNCTIONALITY IN FRONT END USING ASP.NET.
    – prince23
    Oct 24, 2009 at 7:42

You must log in to answer this question.