public ActionResult RestoreDatabase() { var dbPath = Server.MapPath("~/App_Data/DBBackup.bak"); using (var db = new EJIntegralDBEntities()) { var cmd = $"USE master restore DATABASE {"EJIntegralDB"} from DISK='{dbPath}' WITH REPLACE;"; db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd); } return(View()); }
// GET: Backup public ActionResult BackupDatabase() { var dbPath = Server.MapPath("~/App_Data/DBBackup.bak"); using (var db = new EJIntegralDBEntities()) { var cmd = $"BACKUP DATABASE {"EJIntegralDB"} TO DISK='{dbPath}' WITH FORMAT, MEDIANAME='DbBackups', MEDIADESCRIPTION='Media set for {"EJIntegralDB"} database';"; db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, cmd); } return(new FilePathResult(dbPath, "application/octet-stream")); }