Hi there
i would like to back up and restore my entire database ,but seems that there is something wrong with my code , can you please let me know where am i wrong ? thanks
Protected Sub btnBackup_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnBackup.Click
' Dim strCon As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
'Dim sSQL As String = "BACKUP DATABASE "ASPNETDB.MDF" TO DISK = 'D:\Database.bak';"
Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Using myConnection As New SqlConnection(connectionString)
myConnection.Open()
Dim insertSql As String = "BACKUP DATABASE ASPNETDB.MDF TO DISK = 'C:\backup.Bak' "
Dim myCommand As New SqlCommand(insertSql, myConnection)
myCommand.ExecuteNonQuery()
myConnection. ...
Go to the complete details ...