Powershell / Backup SQL Server DBs to Azure Storage with Powershell script

#Variables
param (
[string]$AzureKey= "AzureStorageAccessKey",
[string]$AzureSubs= "YourSubscription",
[string]$AzureStor= "YourStorageAccountName"
)
# Get Context
$containers = New-AzureStorageContext -StorageAccountName $AzureStor -StorageAccountKey $AzureKey
# Get Containers list
Get-AzureStorageContainer -Context $containers

$username="testuser"
$pass = ConvertTo-SecureString "testuserpassword" -AsPlainText -Force
$securecred = New-Object System.Management.Automation.PSCredential ($username, $pass)

#Variables
param (
[string]$instance= "InstanceName"
)
cls
Write-Output ((Get-Date -Format g)+ " - Init MS SMO")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended") | out-null

#Login to SQL Instance
#Use credentials from PSCredential object
$s = new-object ('Microsoft.SqlServer.Management.Smo.Server') $instance
$credential = get-Credential $securecred

#SQL Authentication
$s.ConnectionContext.LoginSecure = $false

$s.ConnectionContext.StatementTimeout = 0
$s.ConnectionContext.Login=$username
$s.ConnectionContext.set_SecurePassword($credential.Password)

#Output
$s.Databases | select name, size, status

# Variables
##################################################
param (
[string]$instance="InstanceName",
[string]$BackupFolderLocalPath="FolderPath",
[string]$AzureKey="AzureKey",
[string]$AzureSubs="AzureSubscription",
[string]$AzureStor="AzureStorageName",
[string[]]$ExcludeDB =("DB1Example","DB2Example")
)
cls

#Empty local buffer path
Write-Output ((Get-Date -Format g) + " - Delete Previous Backups From Local Folder")
Get-ChildItem -Path $BackupFolderLocalPath -Recurse| Foreach-object {Remove-item -Recurse -Force -path $_.FullName }

#Login to SQL Instance
#Use credentials from PSCredential object
$s = new-object ('Microsoft.SqlServer.Management.Smo.Server') $instance
$credential = get-Credential $securecred

#Sets the connection to mixed-mode authentication
$s.ConnectionContext.LoginSecure = $false

$s.ConnectionContext.StatementTimeout = 0
$s.ConnectionContext.Login=$username
$s.ConnectionContext.set_SecurePassword($credential.Password)
$s.Databases | select name, size, status

# Import SQL server objects
Write-Output ((Get-Date -Format g) + " - Init MS SMO")
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") | Out-Null
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum") | Out-Null

Write-output `n
Write-Output ((Get-Date -Format g) + " - Excluded Databases: "+$ExcludeDB)
Write-output `n

#Current date for backup name
$dt= get-date -format yyyyMMddHHmm #We use this to create a file name based on the timestamp

# Backup DBs to the buffer folder
Write-Output ((Get-Date -Format g)+ " - Databases")
$dbs = $s.Databases
foreach ($db in $dbs)
{
$dbname=$db.Name
# Avoid sys dbs and those from excludedb list
if ((-Not $db.IsSystemObject) -and ( $ExcludeDB -notcontains $dbname) -and ($db.Status -eq [Microsoft.SqlServer.Management.Smo.DatabaseStatus]::Normal))
{
Write-Output ((Get-Date -Format g)+ " - Process "+$dbname)
$dbBackup=new-object ("Microsoft.SqlServer.Management.Smo.Backup")
$dbBackup.Action=[Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$dbBackup.BackupSetName= $instance+"_"+$dbname+"_Backup"
$dbBackup.Database=$dbname
$dbBackup.Devices.AddDevice($BackupFolderLocalPath+$dbname+"_db_"+$dt+".bak", "File")
$dbBackup.Incremental=$FALSE
Write-Output ((Get-Date -Format g) + " - StartBackup "+$dbname)
$dbBackup.SqlBackup($s)
Write-Output ((Get-Date -Format g) + " - EndBackup "+$dbname)
}
}

# Create folder on Azure storage account
$ContainerName = [datetime]::now.ToString('yyyy-MM-dd-hh-mm-ss')
$containers = New-AzureStorageContext -StorageAccountName $AzureStor -StorageAccountKey $AzureKey
New-AzureStorageContainer -Name $ContainerName -Permission Off -Context $containers

# Copying to Azure
Write-Output ((Get-Date -Format g) + " - Starting Copy Process To Azure")
$files = Get-ChildItem $BackupFolderLocalPath
foreach($file in $files)
{
$LocalFile=$BackupFolderLocalPath+$file
##$AzureFile=$AzureFolderBackup+"/"+$file
$AzureFile=$file
Set-AzureStorageBlobContent -File $LocalFile -Container $ContainerName -Blob $AzureFile -Context $containers -Force
}

ls -File -Recurse | Set-AzureStorageBlobContent -Container $AzureFolderBackup

Set-AzureStorageBlobContent -File $BackupFolderLocalPath -Container $AzureFolderBackup -Blob $BlobName -Context $containers