I wrote the below code for taking the backup
If str = "backup" Then
SaveFileDialog1.FileName = cmbdatabase.Text
Timer1.Enabled = True
ProgressBar1.Visible = True
Dim s As String
s = SaveFileDialog1.FileName
query("backup database " & cmbdatabase.Text & " to disk='" & s & "'")
But when i m selecting the location using file dialog, it's not creating any backup file
Please tell me the problem.
The backup path should be a valid path on the server and not on the client (you are giving a client side path), the backup command is executed on the server.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)