Backup database

[Mohammed Abdel-Razzak]

Dear sirs
I`m using MS-SQL server to make my database\and connect to
it using C#
is there any way that I can make a backup to my database
using C#

thanks
Mohammed

 

[Guest]

Hi,

To do backup in MS-SQL Server through code you have to use SQL-DMO. SQL-DMO is bascially set of COM components. So to do things using SQL-DMO in C# requires you to use Interop services.

Check out the following code to do backup. This code uses C# and SQL-DMO.

<http://www.sqldev.net/sqldmo/SQL-DMO.NETEventsCS.htm>

Hope this helps...

Regards,
Madhu

Microsoft C# MVP | MCSD.NET

 

[Jim Hughes]

Dear sirs
I`m using MS-SQL server to make my database\and connect to
it using C#
is there any way that I can make a backup to my database
using C#

thanks
Mohammed

You can use the Transact SQL Backup command with the
SqlCommand.ExecuteNonQuery method.

See the SQL BOL for examples of the Backup command.