public override void DoWork() { // Input parameters: // - DATABASE_GROUP // - DATABASE_NAME // - BACKUP_FOLDER // - BACKUP_NAME // - ZIP_BACKUP BackgroundTask topTask = TaskManager.TopTask; string databaseGroup = (string)topTask.GetParamValue("DATABASE_GROUP"); string databaseName = (string)topTask.GetParamValue("DATABASE_NAME"); string backupFolder = (string)topTask.GetParamValue("BACKUP_FOLDER"); string backupName = (string)topTask.GetParamValue("BACKUP_NAME"); string strZipBackup = (string)topTask.GetParamValue("ZIP_BACKUP"); // check input parameters if (String.IsNullOrEmpty(databaseName)) { TaskManager.WriteWarning("Specify 'Database Name' task parameter."); return; } bool zipBackup = (strZipBackup.ToLower() == "true"); if (String.IsNullOrEmpty(backupName)) { backupName = databaseName + (zipBackup ? ".zip" : ".bak"); } else { // check extension string ext = Path.GetExtension(backupName); if (zipBackup && String.Compare(ext, ".zip", true) != 0) { // change extension to .zip backupName = Path.GetFileNameWithoutExtension(backupName) + ".zip"; } } // try to find database SqlDatabase item = (SqlDatabase)PackageController.GetPackageItemByName(topTask.PackageId, databaseGroup, databaseName, typeof(SqlDatabase)); if (item == null) { TaskManager.WriteError("Database with the specified name was not found in the current hosting space."); return; } if (String.IsNullOrEmpty(backupFolder)) { backupFolder = "\\"; } // substitute parameters DateTime d = DateTime.Now; string date = d.ToString("yyyyMMdd"); string time = d.ToString("HHmm"); backupFolder = Utils.ReplaceStringVariable(backupFolder, "date", date); backupFolder = Utils.ReplaceStringVariable(backupFolder, "time", time); backupName = Utils.ReplaceStringVariable(backupName, "date", date); backupName = Utils.ReplaceStringVariable(backupName, "time", time); // backup database DatabaseServerController.BackupSqlDatabase(item.Id, backupName, zipBackup, false, backupFolder); }
public string BackupSqlDatabase(int itemId, string backupName, bool zipBackup, bool download, string folderName) { return(DatabaseServerController.BackupSqlDatabase(itemId, backupName, zipBackup, download, folderName)); }