Script for taking a full backup of a sql express database then cleaning up the previous weeks backups

sql_express_full_backup_and_cleanup.ps1

$limit = (Get-Date).AddDays(-8)
sqlcmd -S pmssql -E -Q "EXEC sp_BackupDatabases @backupLocation='D:\backups\', @backupType='F', @databaseName='dashboard'"

if ($LASTEXITCODE -eq 0) {    
    $path = "D:\backups"

    # Delete files older than the $limit.
    Get-ChildItem -Path $path -Recurse -Force | Where-Object { !$_.PSIsContainer -and $_.CreationTime -lt $limit } | Remove-Item -Force

    # Delete any empty directories left behind after deleting the old files.
    Get-ChildItem -Path $path -Recurse -Force | Where-Object { $_.PSIsContainer -and (Get-ChildItem -Path $_.FullName -Recurse -Force | Where-Object { !$_.PSIsContainer }) -eq $null } | Remove-Item -Force -Recurse
}