hi friends,
i have a problem with
using vb.net application,
i want to restore my database from
my vb.net application so
that user clicks the restore button an OpenDialog open which Open the .bak and then restore the database to a state befor backup taken. i try the follwing code but it not restoring database.

If str
= "restore"
Then
OpenFileDialog1.ShowDialog
()
Timer1.Enabled
= True
ProgressBar1.Visible
= True
query
("RESTORE
DATABASE "
&
cmbdatabase.Text
& " FROM
disk='" & OpenFileDialog1.FileName
& "'")
End If

any help
thank in advance.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.