با سلام مثلا این کد جواب میده
SqlCommand cmd = new SqlCommand();
string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath +
"\\DBAZMOON.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
cmd.Connection = new SqlConnection(connection);
cmd.Connection.Open();
string dbname = cmd.Connection.Database;
cmd.Connection.Close();
SqlConnection.ClearAllPools();
string query = "BACKUP DATABASE [" + dbname + "] TO DISK ='" + saveFileDialog.FileName + "'";
cmd.Connection = new SqlConnection(
"Data Source=.\\sqlexpress;Integrated Security=True;Connect Timeout=30;User Instance=True");
cmd.Connection.Open();
cmd.CommandText = query;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
ولی برای sp کد بعدی خطا عدم وجود این sp رو میده
string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=" + Application.StartupPath +
"\\DBAZMOON.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Connection.Open();
string db = cmd.Connection.Database;
cmd.Connection.Close();
SqlConnection.ClearAllPools();
cmd.Connection = new SqlConnection(
"Data Source=.\\sqlexpress;Integrated Security=True;Connect Timeout=30;User Instance=True");
cmd.CommandText = "myBACKUP";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@path", txtpath.Text + ".bak");
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
MessageBox.Show("نسخه پشتيبان به طور كامل ايجاد شد ", "پيام", MessageBoxButtons.OK,
MessageBoxIcon.Information);