sql-server - 使用 SaveFileDialog vb.net 备份 SQL Server 数据库

Question

这是一些用于备份我们的 SQL Server 2014 数据库的 VB.NET 代码。当我运行代码时，显示的错误消息是“语法错误”。

Dim sqlcon As New SqlConnection With {.ConnectionString = "Server=USMAN; Database=test; Persist Security Info=True; User ID=sa; Password=123"}
Private Sub btnBackUp_Click(sender As Object, e As EventArgs) Handles btnBackUp.Click
    SaveFileDialog1.FileName = DateAndTime.DateString + " - test"
    SaveFileDialog1.Filter = "SQL Server database backup files|*.bak"
    SaveFileDialog1.ShowDialog()
    Dim cmdbak As New SqlCommand("backup database test to disk '" & SaveFileDialog1.FileName & "'", sqlcon)
    sqlcon.Open()
    cmdbak.ExecuteNonQuery()
    MessageBox.Show("Backup has been successfully.")
    sqlcon.Close()
End Sub

标签： sql-servervb.net