Back Up SQL User Databases Using PowerShell

backupUserDatabases.ps1

Import-Module SQLPS -DisableNameChecking -EA 0
# Get the current date
$date = Get-Date -Format yyyyMMdd
# Set location of backup files
$backupPath = "J:\Backups"
$sqlInstance = $env:COMPUTERNAME
# Grab the Databases
$dbNames = Get-ChildItem "SQLSERVER:\SQL\$sqlInstance\DEFAULT\Databases" | Select Name
# Backup the Databases
foreach ($dbName in $dbNames) {
    $db = $dbName.Name.ToString()
    $bakfile = $backupPath + "\" +  $db + "_" + $date + ".bak"
    Write-Verbose("Backing up Database: $db") -Verbose
    $query1 = "BACKUP DATABASE $db TO DISK=N'$bakfile' WITH INIT"
    Invoke-Sqlcmd -SuppressProviderContextWarning -Query $query1 -QueryTimeout 600 
}