c#(window程序)如果备份和恢复数据库 ？？

Question

最近遇到这个问题不懂得如何解决，数据库是sql server2005。希望朋友们多多帮助一下！

Answer 1

http://www.cnblogs.com/njnudt/archive/2007/03/18/678880.html

Answer 2

/// <summary>
        /// 打开路径
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            saveFileDialog1.ShowDialog();
            textBox2.Text = saveFileDialog1.FileName;
        }
        /// <summary>
        /// 开始备份
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text =="")
            {
                MessageBox.Show("请输入要备份数据库的名称或备份路径", "信息提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
            }
            else
            {
                DataSet ds = new DataSet();
                //定义连接SQL Server数据库字符串
                string consqlserver = "server=.;database=MyDatas;uid = sa; pwd = zh2011";
                //定义SQL Server连接对象
                SqlConnection con = new SqlConnection(consqlserver);
                try
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand();
                    //定义备份数据库的SQL语句
                    cmd.CommandText = @"BACKUP DATABASE " + textBox1.Text + " TO disk='"+ textBox2.Text  +"'";
                    //指出通过前面创建的数据库连接执行
                    cmd.Connection = con;
                    //执行SQL语句
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("数据库备份成功", "信息提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);                }
                catch (Exception ex)
                {
                    MessageBox.Show("数据库备份失败", "信息提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
                }
                finally
                {
                    con.Close();
                    con.Dispose();
                }
            }
        }

Answer 3

http://blog.csdn.net/zjcxc/article/details/20074