ADO.NET数据库备份

/// <summary>

/// 备份数据库

/// </summary>

private void btnBackUp_Click(object sender, System.EventArgs e)

{

       this.Cursor = Cursors.WaitCursor;

       this.label1.Text = "  正在进行档案库的数据备份，这可能需要几秒到几十的时间，请稍候...";

       this.label1.Visible = true;

       this.label1.Refresh();

       this.pBar1.Visible = true;

 

       string selfName = “D:/NorthwindBak“;

       string deviceName = “NorthwindBak“;

       string remark = "备份测试";

 

       //数据备份：

       SQLDMO.Backup oBackup = new SQLDMO.BackupClass();

       SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();

       oBackup.Action = 0 ;

       oBackup.Initialize = true ;

       SQLDMO.BackupSink_PercentCompleteEventHandler pceh = new SQLDMO.BackupSink_PercentCompleteEventHandler(Step);

       oBackup.PercentComplete += pceh;

       try

       {

              oSQLServer.LoginSecure = false;

              oSQLServer.Connect(Common.MySettings.SqlServerName, "sa", "");

              oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;

              oBackup.Database = "Northwind";//数据库名

              oBackup.Files = selfName;//文件路径

              oBackup.BackupSetName = deviceName;//备份名称

              oBackup.BackupSetDescription = remark;//备份描述

              oBackup.Initialize = true;

              oBackup.SQLBackup(oSQLServer);

 

       }

       catch(System.Exception ex)

       {

              Common.ShowMsg("数据备份失败：/n" + ex.ToString());

       }

       finally

       {

              oSQLServer.DisConnect();

       }

       //------------------------------------------------------------------------------------

       this.label1.Visible = false;

       this.pBar1.Visible = false;

       this.Cursor = Cursors.Default;

}

 

/// <summary>

/// 显示备份进度条

/// </summary>

private void Step(string message,int percent)

{

       this.pBar1.Value = percent ;

}

 

/// <summary>

/// 还原数据库

/// </summary>

private void btnRestore_Click(object sender, System.EventArgs e)

{

       this.Cursor = Cursors.WaitCursor;

       this.label1.Text = "  正在进行档案库的数据还原，这可能需要几秒到几十的时间，请稍候...";

       this.label1.Visible = true;

       this.label1.Refresh();

       this.pBar1.Visible = true;

 

       string fileName = "NorthwindBak";

       string filePath = "D:/NorthwindBak";

       string remark = "备份测试";

       SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();

       SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();

       oRestore.Action = 0 ;

       SQLDMO.RestoreSink_PercentCompleteEventHandler pceh = new SQLDMO.RestoreSink_PercentCompleteEventHandler(Step);

       oRestore.PercentComplete += pceh;

       try

       {

              oSQLServer.Connect(Common.MySettings.SqlServerName, "sa", "");

              SQLDMO.QueryResults qr = oSQLServer.EnumProcesses(-1) ;

              int iColPIDNum = -1 ;

              int iColDbName = -1 ;

              //杀死其它的连接进程

              for(int i=1;i<=qr.Columns;i++)

              {

                     string strName = qr.get_ColumnName(i) ;

                     if (strName.ToUpper().Trim() == "SPID")

                     {

                         iColPIDNum = i ;

                     }

                     else if (strName.ToUpper().Trim() == "DBNAME")

                     {

                         iColDbName = i ;

                     }

                     if (iColPIDNum != -1 && iColDbName != -1)

                         break ;

              }

              for(int i=1;i<=qr.Rows;i++)

              {

                     int lPID = qr.GetColumnLong(i,iColPIDNum) ;

                     string strDBName = qr.GetColumnString(i,iColDbName) ;

                     if (strDBName.ToUpper() == "CgRecord".ToUpper())

                         oSQLServer.KillProcess(lPID) ;

              }

 

              oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;

              oRestore.Database = "Northwind";

              oRestore.Files = filePath;

              oRestore.FileNumber = 1;

              oRestore.ReplaceDatabase = true;

              oRestore.SQLRestore(oSQLServer);

       }

       catch(System.Exception ex)

       {

           Common.ShowMsg("数据还原失败：/n" + ex.ToString());

       }

       finally

       {

              oSQLServer.DisConnect();

       }

 

       this.label1.Visible = false;

       this.pBar1.Visible = false;

       this.Cursor = Cursors.Default;

}

 

/// <summary>

/// 显示还原进度条

/// </summary>

private void Step(string message,int percent)

{

       this.pBar1.Value = percent ;

}