winform 数据库备份

private void ButtonBackUp_Click(object sender, System.EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            string _DBServ = Btnback1.Text;
            string _DBName = Btnback2.Text;
            string _DBUser = Btnback3.Text;
            string _DBPass = Btnback4.Text;
           
            string m_ConnectionStr   = "data source="+_DBServ+";initial catalog=master;user id="+_DBUser+";pwd="+_DBPass+";Connect Timeout=5;";
            SqlConnection _Conn = new SqlConnection(m_ConnectionStr);           
            try
            {
                _Conn.Open();
                SaveFileDialog _SaveFileDialog = new SaveFileDialog();         //保存的文件目录路径      
                _SaveFileDialog.Title = "请选择备份保存的目录";
                _SaveFileDialog.Filter="(*.Bak)|*.Bak;|(All Files)|*.*";
                if(_SaveFileDialog.ShowDialog()==DialogResult.OK)
                {
                     
                    string _FolderPath = _SaveFileDialog.FileName;                                          
                   
                    SqlCommand _Comm = new SqlCommand("",_Conn);
                    //执行数据库备份命令
                    //_Comm.CommandText = "BACKUP DATABASE "+_DBName+" TO DISK = "+ _FolderPath +" ";
                    _Comm.CommandText = "BACKUP DATABASE "+_DBName+" TO DISK = '"+ _FolderPath +"' ";
                    _Comm.ExecuteNonQuery();                   
                    this.Cursor = Cursors.Arrow;
                    _Conn.Close();
                    MessageBox.Show("备份数据成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                }
                this.Cursor = Cursors.Arrow;

            }
            catch(System.Exception error)
            {
                this.Cursor = Cursors.Arrow;
                MessageBox.Show("异常:"+error.Message,"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
            this.Cursor = Cursors.Arrow;
        }

        private void buttonXP1_Click(object sender, System.EventArgs e)
        {
            OpenFileDialog _OpenFileDialog = new OpenFileDialog();
            _OpenFileDialog.Title="请选择文件恢复";
            _OpenFileDialog.Filter="(*.Bak)|*.Bak;|(All Files)|*.*";
            if (_OpenFileDialog.ShowDialog() == DialogResult.OK)
            {
                BtnRestory.Text=_OpenFileDialog.FileName;
            }
        }

        private void ButtonRestory_Click(object sender, System.EventArgs e)
        {
            if(MessageBox.Show("该操作将数据覆盖!!\n\n如果选择[是],将原来的数据覆盖\n\n如果选择[否],将取消恢复","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Question)==DialogResult.No)
                return;
            if(MessageBox.Show("请再次确认,该操作不能恢复!!\n\n如果选择[是],将原来的数据覆盖\n\n如果选择[否],将取消恢复","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.No)
                return;
            this.Cursor = Cursors.WaitCursor;

            string _DBServ = R1.Text;
            string _DBName = R2.Text;
            string _DBUser = R3.Text;
            string _DBPass = R4.Text;

            string m_ConnectionStr   = "data source="+_DBServ+";initial catalog=master;user id="+_DBUser+";pwd="+_DBPass+";Connect Timeout=5;";
            SqlConnection _Conn = new SqlConnection(m_ConnectionStr);           
            try
            {
                _Conn.Open(); 
                //SqlCommand _Comm = new SqlCommand("restore filelistonly from disk='"mailto:+_FolderPath+@%22\%22+_DBName+@%22.bak'%22,_Conn);//获得原来的逻辑名称以及物理路径
                string _FolderPath="d:";
                string _DBPath = "ces";
                SqlCommand _Comm = new SqlCommand("restore filelistonly from disk='"mailto:+_FolderPath+@%22\%22+_DBPath+@%22.bak'%22,_Conn);//获得原来的逻辑名称以及物理路径
                SqlDataReader _Reader = null;
                _Reader = _Comm.ExecuteReader();
                string[]  _LogName = new string[2];//获得逻辑名称
                string[]  _PhiPath = new string[2];//获得物理路径
                int j = 0;
                while(_Reader.Read())
                {
                    _LogName[j] = (string)_Reader.GetValue(0);
                    _PhiPath[j] = (string)_Reader.GetValue(1);
                    j = j+1;
                }
                _Reader.Close();
                MessageBox.Show(_LogName[0]);
                       
                //执行数据库恢复脚本
                _Comm = new SqlCommand("",_Conn);
                _Comm.CommandText ="RESTORE DATABASE [" + _DBName + "]   FROM DISK = '" + BtnRestory.Text + "' With Move '"+ _LogName[0] +
                    "' TO '" +_PhiPath[0]+ "',  Move '" + _LogName[1] + "' TO '" + _PhiPath[1]+ "'";
                _Comm.ExecuteNonQuery();                   
                           
                this.Cursor = Cursors.Arrow;
                MessageBox.Show("数据恢复成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                _Conn.Close();
                      
                this.Cursor = Cursors.Arrow;

            }
            catch(System.Exception error)
            {
                this.Cursor = Cursors.Arrow;
                MessageBox.Show("异常:"+error.Message,"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
        }

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/regedit362451dennis/archive/2005/08/19/458618.aspx