# Directory where to store the backups
$configBackupDir = "backup"
# Number of backups to keep, set to 0 to keep all backups
-$configRotate = 7
+$configBackupRotate = 7
# Directory where to store the logfiles
$configLogDir = "log"
# Number of logfiles to keep, set to 0 to keep all logfiles
-# You should set this to at least the same as $configRotate
+# You should set this to at least the same as $configBackupRotate
$configLogRotate = 7
# Databases to backup, leave empty to backup all databases
}
if($keepFilesCount -eq -1) {
- Write-Output "Deleting file $($_.FullName)"
-
if($null -ne $LogFile) {
Write-Log "Deleting file $($_.FullName)" -Path $LogFile
}
Write-Log $_ -Path $logFile -Level Error
Write-Log "Exiting" -Path $logFile -Level Error
- Write-Output "Failed to get list of databases"
- Write-Output $_
-
exit 1
}
}
else {
Write-Log "Not backing up database $cDb, because it does not exist" -Path $logFile -Level Warn
- Write-Warning "Not backing up database $cDb, because it does not exist"
}
}
}
Write-Log $_ -Path $logFile -Level Error
Write-Log "Exiting" -Path $logFile -Level Error
- Write-Output "Failed to create directory $databaseBackupDir"
- Write-Output $_
-
exit 1
}
}
$databaseBackupFile = Join-Path -Path $databaseBackupDir -ChildPath "backup-$d-$currDaytime.sql"
Write-Log "Backing up $d to $databaseBackupFile..." -Path $logFile
- Write-Output "Backing up $d to $databaseBackupFile..."
try {
Create-Backup $d $databaseBackupFile
- Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configRotate -Pattern $patternBackupFile -LogFile $logFile
+ Invoke-FileRotation -Dir $databaseBackupDir -MaxFiles $configBackupRotate -Pattern $patternBackupFile -LogFile $logFile
}
catch {
Write-Log "Could not backup database $d to $databaseBackupFile" -Path $logFile -Level Error
Write-Log $_ -Path $logFile -Level Error
-
- Write-Output "Could not backup database $d to $databaseBackupFile"
- Write-Output $_
}
}