c#数据库备份到指定路径

          //备份数据库

          try
            {
                string connection = "SERVER='.';DATABASE=temdb; TRUSTED_CONNECTION=true;"; ;
                SaveFileDialog sf = new SaveFileDialog();//打开选择路径的对话框
                sf.Filter = "bak files (*.bak)|*.bak";
                sf.FilterIndex = 1;
                sf.Title = "";
                if (sf.ShowDialog() == DialogResult.OK)
                {
                    string filepath = sf.FileName.ToString();//取得选择的完整路径
                    string sql = string.Format("Backup database temdb to disk = '{0}'", filepath); //备份数据库语句
                    SqlConnection con = new SqlConnection(connection);
                    con.Open();
                    SqlCommand command = new SqlCommand(sql, con);
                    command.ExecuteNonQuery();
                    con.Close();
                    MessageBox.Show("数据库备份成功！");
                }
            }
            catch (Exception ex)
            {

                MessageBox.Show("数据库备份失败！"+ ex.Message);
            }