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);
}
