any code ? to backup database that we using ? in c#

[wondery]

i want user can backup database by click button

[PlausiblyDamp]

What database are you using?

[wondery]

mssql

[PlausiblyDamp]

System.Data.SqlClient.SqlConnection conn = new  System.Data.SqlClient.SqlConnection();
	System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();

	//Open connection as per usual
	conn.ConnectionString="Data Source=.;Initial Catalog=Northwind;uid=sa";
	conn.Open();
	//backup database
	cmd.Connection=conn;
	cmd.CommandText="BACKUP DATABASE  TO DISK = '' ";
	cmd.ExecuteNonQuery();

[wondery]

it error

 

Could not locate entry in sysdatabases for database 'newattorney'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

 

Exception Details: System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'newattorney'. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally.

 

System.Data.SqlClient.SqlConnection conn = new  System.Data.SqlClient.SqlConnection();
		System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();

		//Open connection as per usual
		conn.ConnectionString="Data Source=.;Initial Catalog=attorney;uid=sa;password=xxx";
		conn.Open();
		//backup database
		cmd.Connection=conn;
		cmd.CommandText="BACKUP DATABASE newattorney TO DISK = '" + Server.MapPath("backup/") + "'";
		cmd.ExecuteNonQuery();