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