欧美成人精品手机在线观看_69视频国产_动漫精品第一页_日韩中文字幕网 - 日本欧美一区二区

            private void btnBak_Click(object sender, EventArgs e) //備份
        {
            string saveAway = this.tbxBakLoad.Text.ToString().Trim();
            string cmdText = @"backup database " + System.Configuration.ConfigurationSettings.AppSettings["dbName"] + " to disk=''" + saveAway + "''";
            BakReductSql(cmdText,true);            
        }

 

        private void btnReduct_Click(object sender, EventArgs e)  //恢復(fù)
        {
            string openAway = this.tbxReductLoad.Text.ToString().Trim();//讀取文件的路徑
            string cmdText = @"restore database " + System.Configuration.ConfigurationSettings.AppSettings["dbName"] + " from disk=''" + openAway + "''";            
            BakReductSql(cmdText,false);
        }

 

        /// <summary>
        /// 對數(shù)據(jù)庫的備份和恢復(fù)操作，Sql語句實現(xiàn)
        /// </summary>
        /// <param name="cmdText">實現(xiàn)備份或恢復(fù)的Sql語句</param>
        /// <param name="isBak">該操作是否為備份操作，是為true否，為false</param>
        private void BakReductSql(string cmdText,bool isBak)
        {
            SqlCommand cmdBakRst = new SqlCommand();
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=master;uid=sa;pwd=;");

            try
            {
                conn.Open();
                cmdBakRst.Connection = conn;
                cmdBakRst.CommandType = CommandType.Text;
                if (!isBak)     //如果是恢復(fù)操作
                {
                    string setOffline = "Alter database GroupMessage Set Offline With rollback immediate ";
                    string setOnline = " Alter database GroupMessage Set Online With Rollback immediate";
                    cmdBakRst.CommandText = setOffline + cmdText + setOnline;
                }
                else
                {
                    cmdBakRst.CommandText = cmdText;
                }
                cmdBakRst.ExecuteNonQuery();
                if (!isBak)
                {
                    MessageBox.Show("恭喜你，數(shù)據(jù)成功恢復(fù)為所選文檔的狀態(tài)！", "系統(tǒng)消息");
                }
                else
                {
                    MessageBox.Show("恭喜，你已經(jīng)成功備份當前數(shù)據(jù)！", "系統(tǒng)消息");
                }
            }
            catch (SqlException sexc)
            {
                MessageBox.Show("失敗，可能是對數(shù)據(jù)庫操作失敗，原因：" + sexc, "數(shù)據(jù)庫錯誤消息");
            }
            catch (Exception ex)
            {
                MessageBox.Show("對不起，操作失敗，可能原因：" + ex, "系統(tǒng)消息");
            }
            finally
            {
                cmdBakRst.Dispose();
                conn.Close();
                conn.Dispose();
            }
        }

 

                   

2.用SQLDMO實現(xiàn)（下面代碼引用別人的）

    //數(shù)據(jù)庫備份
        string backaway =textbox1.Text.Trim();
            SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
            SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
            try
            {
                oSQLServer.LoginSecure = false;
                //下面設(shè)置登錄sql服務(wù)器的ip,登錄名,登錄密碼
                oSQLServer.Connect(serverip, serverid, serverpwd);
                oBackup.Action = 0;
               //下面兩句是顯示進度條的狀態(tài)
                SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(Step2);
                oBackup.PercentComplete += pceh;
                //數(shù)據(jù)庫名稱:
                oBackup.Database = "k2";
                //備份的路徑
                oBackup.Files = @backaway;
                //備份的文件名
                oBackup.BackupSetName = "k2";
                oBackup.BackupSetDescription = "數(shù)據(jù)庫備份";
                oBackup.Initialize = true;
                oBackup.SQLBackup(oSQLServer);
                MessageBox.Show("備份成功！", "提示");
            }
            catch
            {
                MessageBox.Show("備份失敗！", "提示");
            }
            finally
            {
                oSQLServer.DisConnect();
            }



//數(shù)據(jù)庫恢復(fù)
        //獲取恢復(fù)的路徑
        string dbaway = textbox2.Text.Trim();
            SQLDMO.Restore restore = new SQLDMO.RestoreClass();
            SQLDMO.SQLServer server = new SQLDMO.SQLServerClass();
            server.Connect(serverip, serverid, serverpwd);

            //KILL DataBase Process
            conn = new 工資管理系統(tǒng).CCUtility.connstring();
            conn.DBOpen();
            SqlCommand cmd = new SqlCommand("use master Select spid FROM sysprocesses ,sysdatabases Where sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name=''k2''", conn.Connection);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                server.KillProcess(Convert.ToInt32(dr[0].ToString()));
            }
            dr.Close();
            conn.DBClose();

            try
            {
                restore.Action = 0;
                SQLDMO.RestoreSink_PercentCompleteEventHandler pceh = new SQLDMO.RestoreSink_PercentCompleteEventHandler(Step); 
                restore.PercentComplete += pceh;
                restore.Database = "k2";
                restore.Files = @dbaway;
                restore.ReplaceDatabase = true;
                restore.SQLRestore(server);
                MessageBox.Show("數(shù)據(jù)庫恢復(fù)成功！");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                server.DisConnect();
            }

恢復(fù)相關(guān)的參數(shù)和備份相同,不再解釋,自己看一下.

上面兩個函數(shù)調(diào)用到了更改進度條的兩個函數(shù):

       private void Step2(string message, int percent)
        {
            progressBar2.Value = percent;
        }

        private void Step(string message, int percent)
        {
            progressBar1.Value = percent;
        }

setp對應(yīng)備份,,setp2對應(yīng)恢復(fù)....