I am trying to back up a local database, but I alway get the same error:Incorrect syntax near '.' Who can help me with this?

[AntoonC]

Dim sqlcon As New SqlConnection
Dim sqlcmd As New SqlCommand
Dim dbname As String = "Requirements.mdf"

'connection string voor database PermitFees
sqlcon.ConnectionString = My.Settings.RequirementsConnectionString & ";Initial Catalog=CustomerDatabase;Integrated Security=True"

'destination folder
Dim destdir As String = "G\test.bak"

sqlcon.Open()

Dim strQuery = "Backup database Requirements.mdf To Disk=G:\test.bak"
sqlcmd = New SqlCommand(strQuery, sqlcon)


sqlcmd.ExecuteNonQuery()
sqlcon.Close()

Continue reading...