PowerShell script for sql server database backup with timestamp file name.

backup.ps1

$dt = Get-Date -Format yyyyMMddHHmmss
$dbname = 'dfi'
$username = 'DFINewWebsiteSI'
#read-host -assecurestring | convertfrom-securestring | out-file sqlsecure.txt
$password = Get-Content sqlsecure.txt
$secpasswd = $password | ConvertTo-SecureString
$credential = New-Object System.Management.Automation.PSCredential -ArgumentList $username,$secpasswd
$bakfile = "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\dfi_$($dt).bak"

Write-Output "backup database to disk file = $bakfile"

Backup-SqlDatabase -ServerInstance DFINW -Database $dbname -Credential $credential -BackupFile $bakfile