$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()
Comments