[PS] backup SQL Server db

$dbserver = 'sql.acme.com'
$dbname = 'My_DB'


# load dlls

[System.Reflection.Assembly]::Load("System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089") | Out-Null

$dat = (get-date).ToString("yyyyMMddHHmm")

$connStr = "Data Source=$($dbserver);Initial Catalog=$($dbname);Persist Security Info=True;Integrated Security=SSPI;"
$sql = "BACKUP DATABASE [$($dbname)] TO  DISK = N'\\NETWORKSHARE.INTERNAL\Files$\temp\$($dbname)_$($dat).bak' WITH NOFORMAT, NOINIT,  NAME = N'$($dbname)-Full Database Backup', SKIP, NOREWIND, NOUNLOAD;"

$conn = New-Object System.Data.SqlClient.SqlConnection($connStr)
$conn.Open();

$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.Connection = $conn
$cmd.CommandText = $sql
$cmd.CommandType = [System.Data.CommandType]::Text

$cmd.ExecuteNonQuery()

$conn.Close()
$conn.Dispose()