C#使用SQLDMO实现对MSSQL数据库进行备份和恢复

public sealed class DbOper
{
     ///<summary>
     /// DbOper类的构造函数
     ///</summary>
     private DbOper()
     {
     }
     ///<summary>
     /// 数据库备份
     ///</summary>
     public static void DbBackup()
     {
          SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
          SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
         try
         {
              oSQLServer.LoginSecure = false;
              oSQLServer.Connect("localhost", "sa", "1234");
              oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
              oBackup.Database = "Northwind";
              oBackup.Files = @"d:\Northwind.bak";
              oBackup.BackupSetName = "Northwind";
              oBackup.BackupSetDescription = "数据库备份";
              oBackup.Initialize = true;
              oBackup.SQLBackup(oSQLServer);
         }
      &nbs