Question

i am using the following code snippet to backup/restore database

备份工作罚款,但一经尝试恢复这一错误

<><>>RESTORE不能处理LLC数据库,因为该数据库在本届会议使用。建议使用主数据库进行这项工作。 RESTORE DATABASE正在终止异常的。

If strAction = Action.BackUp Then

            strQuery = "BACKUP DATABASE LIC to disk= C:BackupICLS.bak "
        Else

            strQuery = "RESTORE DATABASE LIC FROM disk= C:BackupICLS.bak "

        End If

        Dim cmd As SqlCommand
        cmd = New SqlCommand(strQuery, con)
        cmd.ExecuteNonQuery()
        MsgBox("Restore Done")

Answer 1

Like the message says, you are connected to the database you re trying to restore. Change your connection string to use the Master database and then restore.

友情链接