public bool SaoLuuCoSoDuLieu(DTO_Backup_Restore bare) { try { if (bare.ThuMucBackup.Equals("")) return false; connection.MoKetNoi(); sql = "BACKUP DATABASE " + bare.TenCoSoDuLieu + " TO DISK = '" + bare.ThuMucBackup + "\\" + bare.TenCoSoDuLieu + "-" + DateTime.Now.Day+"-"+DateTime.Now.Month+"-"+DateTime.Now.Year+".bak'"; //sql = "BACKUP DATABASE " + bare.TenCoSoDuLieu + " TO DISK = 'D:\\backup\\data.bak'"; cmd = new SqlCommand(sql, connection.connect); cmd.ExecuteNonQuery(); //connection.DongKetNoi(); return true; } catch (Exception e) { Console.WriteLine(e.Message); return false; } }
public bool PhucHoiCoSoDuLieu(DTO_Backup_Restore bare) { try { if (bare.FileRestore.Equals("")) return false; connection.MoKetNoi(); sql = "USE master;"; sql += " ALTER DATABASE "+bare.TenCoSoDuLieu+" SET SINGLE_USER WITH ROLLBACK IMMEDIATE;"; sql += " RESTORE DATABASE " + bare.TenCoSoDuLieu + " FROM DISK = '"+bare.FileRestore+"' WITH REPLACE;"; sql += " ALTER DATABASE " + bare.TenCoSoDuLieu + " SET MULTI_USER;"; cmd = new SqlCommand(sql, connection.connect); cmd.ExecuteNonQuery(); //connection.DongKetNoi(); return true; } catch (Exception e) { Console.WriteLine(e.Message); return false; } }
public bool SaoLuuDuLieu(DTO_Backup_Restore backuprestore) { return dal_backuprestore.SaoLuuCoSoDuLieu(backuprestore); }
public bool PhucHoiDuLieu(DTO_Backup_Restore backuprestore) { return dal_backuprestore.PhucHoiCoSoDuLieu(backuprestore); }