English 中文(简体)
这一过程不能查阅档案,因为它是否被另一个过程使用......任何想法?
原标题:The Process Cannot Access The File Because It Is Being Used By Another Process...Any Ideas?

我正在使用以下代码表,复制/更新数据库。

Public Sub backupData()
        Try

            Dim s As StreamWriter

            Dim portfolioPath As String = Environment.CurrentDirectory
             MsgBox(Application.UserAppDataPath)
            If Not Directory.Exists(LIC.My.Settings.BackupDirectory) Then

                Directory.CreateDirectory(LIC.My.Settings.BackupDirectory)

                File.Create(LIC.My.Settings.BackupDirectory & "LIC.Mdf").Close()

                File.Create(LIC.My.Settings.BackupDirectory & "Backup log.rtf").Close()

                s = New StreamWriter(LIC.My.Settings.BackupDirectory & "Backup log.rtf", True)

                s.WriteLine("This backup was initially taken on - " & Date.Now)

                s.Flush()

                s.Close()

                FileCopy(portfolioPath & "LIC.mdf", LIC.My.Settings.BackupDirectory & "LIC.Mdf")

                s = New StreamWriter(LIC.My.Settings.BackupDirectory & "Backup log.rtf", True)

                MsgBox("New directory and backup file created")

            Else
                FileCopy(portfolioPath & "LIC.mdf", LIC.My.Settings.BackupDirectory & "LIC.Mdf")

                s = New StreamWriter(LIC.My.Settings.BackupDirectory & "Backup log.rtf", True)

                s.WriteLine("This backup was latest updated on - " & Date.Now)

                s.Flush()

                s.Close()

                MsgBox("Back up completed successfully")

            End If



        Catch ex As Exception

            Dim MessageString As String = "Report this error to the system administrator: " & ControlChars.NewLine & ex.Message

            Dim TitleString As String = "Data Backup Failed"

            MessageBox.Show(MessageString, TitleString, MessageBoxButtons.OK, MessageBoxIcon.Error)

        End Try
    End Sub

But i get an error *"The Process Cannot Access The File Because It Is Being Used By Another Process"*Any Idea How Can I Copy/Backup The Files??

最佳回答

除非你先关闭服务器库,否则你将无法复制文件。

说到这一点,实际上没有任何理由使用QIDDMO或上述方法支持数据库;可以通过简单的Transactkou进行:

BACKUP DATABASE MyDatabase TO DISK =  MyDatabase.bak  WITH FORMAT

This will back the database up to SQL Server s default backup directory (which I believe you specify at installation).

备份指挥和

问题回答

暂无回答




相关问题
Is Shared ReadOnly lazyloaded?

I was wondering when I write Shared ReadOnly Variable As DataType = New DataType() Or alternatively Shared ReadOnly Variable As New DataType() Is it lazy loaded or as the instance initializes? ...

Entertaining a baby with VB.NET

I would like to write a little application in VB.NET that will detect a baby s cry. How would I get started with such an application?

Choose Enter Rather than Pressing Ok button

I have many fields in the page and the last field is a dropdown with list of values. When I select an item in a dropdown and press Enter, it doesn t do the "Ok". Instead I have to manually click on Ok ...

ALT Key Shortcuts Hidden

I am using VS2008 and creating forms. By default, the underscore of the character in a textbox when using an ampersand is not shown when I run the application. ex. "&Goto Here" is not ...

Set Select command in code

On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong? protected void bttnView_Click(object sender, ...

Hover tooltip on specific words in rich text box?

I m trying to create something like a tooltip suddenly hoovering over the mouse pointer when specific words in the richt text box is hovered over. How can this be done?

热门标签