PowerShell to Backup and ZIP SQL Server Database

http://bit.do/dfuhs Secret discount page at HandyBackup.
Script below. Enjoy! # Create Variables $Server = 'SERVERNAME' $Database = 'HackKittyCRM' $TempFolder = "D:\Temp\" $BackUpFolder = "D:\db\backups\" $dt = get-date -format MM-dd-yyyy $FilePath = "$($TempFolder)$($Database)_db_$($dt).bak" #Call SQL Command Backup-SqlDatabase -ServerInstance $Server -Database $Database -BackupFile $FilePath #Zip the Backup (BAK) that is created Add-Type -Assembly "System.IO.Compression.FileSystem" ; [System.IO.Compression.ZipFile]::CreateFromDirectory($TempFolder, "D:\db\backups\$($Database)_db_$($dt).zip") ; # Remove THIS .bak file to save space Remove-Item $FilePath # Remove Old ZIP backups Files. Our retention is 7 days $OldFile = (get-date).AddDays(-14).ToString("MM-dd-yyyy") Remove-Item "$($BackupFolder)*$OldFile*" $FTPFolder = "D:\FTPlocation\" # CLEAN OUT FTP FOLDER Remove-Item $FTPFolder"*" -Recurse -force #Copy TODAY's ZIP SO we can FTP it #Write-Host $FTPFolder$($Database)_db_$($dt)".zip" Copy-Item -Path $BackUpFolder$($Database)_db_$($dt)".zip" -Destination $FTPFolder$($Database)_db_$($dt)".zip" -Recurse -force