[轉貼]ASP.NET下對遠程SQL SERVER資料庫的備份和恢複的預存程序

Sql server的協助文檔地址，在IE裡面直接輸入就行
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsqlref.chm::/ts_ba-bz_35ww.htm

backup database to disk path備份
restore database from disk path恢複

using System;
using System.Collections;
using System.Security.Cryptography;

using System.Data;
using System.Data.SqlClient;
using System.Web;

using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Diagnostics ;
using System.Text ;
using System.ComponentModel;
using System.Configuration;
using System.Data.OleDb;

namespace DbService
{
 /// <summary>
 /// DbOper類,主要實現對Microsoft SQL Server資料庫的備份和恢複
 /// </summary>
 public sealed class DbOper
 {
  /// <summary>
  /// DbOper類的建構函式
  /// </summary>
  //private DbOper()
  //{
  //}

  /// <summary>
  /// Database Backup
  /// </summary>
  ///
  public static string BackFileName=System.Web.HttpContext.Current.Request.PhysicalApplicationPath+"BackUp\\MyDbBack.bak";
  public static void DbBackup(string DbNanme,string userid,string pwd)
  {
   try
   {
    SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
    SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
    oSQLServer.LoginSecure = false;
    oSQLServer.Connect("localhost",userid,pwd);
    oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
    oBackup.Database = DbNanme;
    oBackup.Files =BackFileName;
    oBackup.BackupSetName =DbNanme;
    oBackup.BackupSetDescription = "Database Backup";
    oBackup.Initialize = true;
    oBackup.SQLBackup(oSQLServer);
   }
   catch
   {
    throw;
   }
  }

  

  /// <summary>
  /// 還原資料庫函數
  /// </summary>
  /// <param name="strDbName">資料庫名</param>
  /// <param name="strFileName">Database Backup檔案的完整路徑名</param>
  /// <returns></returns>
  public bool RestoreDB(string strDbName,string strFileName,string userid,string pwd)
  {
   //PBar = pgbMain ;
   SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass() ;
   try
   {
    //伺服器名，資料庫使用者名稱，資料庫使用者名稱密碼
    svr.Connect("localhost",userid,pwd) ;
    
    SQLDMO.QueryResults qr = svr.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 ;
    }
    //殺死使用strDbName資料庫的進程
    for(int i=1;i<=qr.Rows;i++)
    {
     int lPID = qr.GetColumnLong(i,iColPIDNum) ;
     string strDBName = qr.GetColumnString(i,iColDbName) ;
     if (strDBName.ToUpper() == strDbName.ToUpper())
     {
      svr.KillProcess(lPID) ;
     }
    }
               
    SQLDMO.Restore res = new SQLDMO.RestoreClass() ;
    res.Action = 0 ;
    res.Files = strFileName ;

    res.Database = strDbName ;
    res.ReplaceDatabase = true ;
    res.SQLRestore(svr) ;
    return true ;
   }
   catch
   {
    return false;
   }
   finally
   {
    svr.DisConnect() ;
   }
  }

 }
}