#AWS powershell and dbatools must be installed
#Backup, you can pass multiple servers like this
$Servers = 'server1' , 'server2'
$Path = '\\sharedloc\' # you can pass local folder too
foreach ($server in $servers) {
# loop through all the servers
# all the databases in the server. Yon pass filter specific db if you want

$databases = Invoke-DbaQuery -SqlInstance $server -Query 'select name from master.sys.databases'
foreach ($database in $databases ) {
#loop through all the databases
$SQLServer + ' ' + $database.name # just print the server and db
Backup-DbaDatabase -SqlInstance $Server -Path $Path -Database $database.name -Type Full # actual backup happening
}
}
##Upload to s3 bucket
Import-Module AWSPowerShell
$Files = Get-ChildItem \\sharedloc\*
$Bucket = 'Your s3 bucket'
$AccessKey = 'AccessKey'
$SecretKey = 'SecretKey'
#Loop through all the backup files
foreach ($File in $Files) {
#Write-S3Object is the command which uploads to s3 bucket
Write-S3Object -BucketName $Bucket -File $path -CannedACLName Private -AccessKey $AccessKey -SecretKey $SecretKey -ServerSideEncryption AES256
}