Backup sql database error

Question

Hi everyone

I made a program for backup sql database. when i back up there's an error show like this

Cannot open backup device 'C:\\aw.bak'. Operating system error 5(Access is denied.).

BACKUP DATABASE is terminating abnormally.

 

what it's means Operation system error 5? it's about on my os?. by d way this is my code

Public Class Form1
    Dim cmd As SqlCommand
    Dim conn As SqlConnection

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        conn = New SqlConnection("Data Source=RYAN-PC\RYAN;Initial Catalog=trydb;User ID=sa;Password=12345")
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim saveFileDialog1 As New SaveFileDialog()
        Dim mybackup As String
        saveFileDialog1.Filter = "Backup Files (*.bak)|*.bak"
        saveFileDialog1.FilterIndex = 2
        saveFileDialog1.RestoreDirectory = True

        If saveFileDialog1.ShowDialog() = DialogResult.OK Then
            mybackup = Path.GetDirectoryName(saveFileDialog1.FileName) + "\" + Path.GetFileName(saveFileDialog1.FileName)
            Label1.Text = mybackup
            cmd = New SqlCommand(" BACKUP DATABASE [trydb] TO DISK = '" & mybackup & "' ", conn)
            conn.Open()
            cmd.ExecuteNonQuery()
            conn.Close()
            MsgBox("backup success!")
        End If

    End Sub
End Class

Answer 1

By the way problem solved.. I change the log on that i used sql service into the Local System

Answer 2

Hi Witwew,

Thank you for sharing your solution here.

Best regards,

---

Mike Feng [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

no problem