C#数据备份与还原

来源：互联网发布：用友t3安装数据库编辑：程序博客网时间：2024/05/19 12:18

///<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);
         }
         catch
         {
              throw;
         }
          finally
         {
              oSQLServer.DisConnect();
         }
     }

     ///<summary>
     /// 数据库恢复
     ///</summary>
     public static void DbRestore()
     {
          SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
          SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
         try
         {
              oSQLServer.LoginSecure = false;
              oSQLServer.Connect("localhost", "sa", "1234");
              oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
              oRestore.Database = "Northwind";
              oRestore.Files = @"d:/Northwind.bak";
              oRestore.FileNumber = 1;
              oRestore.ReplaceDatabase = true;
              oRestore.SQLRestore(oSQLServer);
         }
         catch
         {
              throw;
         }
          finally
         {
              oSQLServer.DisConnect();
         }
     }
}