Backup MS SQL Database via Powershell
$dbName = $((Get-Date).tostring(“yyyy-MM-dd”))
Backup-SqlDatabase -ServerInstance BQESRVBQE -Database BQEDIVENG2019 -BackupAction Database -BackupFile “\DEIDROBODBBACKUP$dbName.bak”
Backup Files from One Location to Another
$bakdate = $((Get-Date).tostring(“yyyyMMdd”))
net use Y: \10.0.1.205Public
net use w: \deidroboPublic
robocopy Y: W:Backups$bakdate /E /ZB /DCOPY:T /R:2 /W:1 /LOG:W:Logs$bakdate.log