Powershell Scripts

A couple of small PowerShell utilities I use often enough to keep handy.

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