高考问答飞机大战1945:怎样用语言对SQL数据库进行备份？
来源：百度文库 编辑：高考问答 时间：2024/05/02 19:08:44
主要是VB，VB.NET语言！
望各位高手指点
要对数据库进行恢复 又该怎样写了
谢谢了
望各位高手指点
要对数据库进行恢复 又该怎样写了
谢谢了
给你一段备份数据库的代码：
'备份数据库
'BackupDataName数据库存放的绝对路径
Function BackUpData(ByVal BackupDataName As String) As String
Dim Conn As New SqlClient.SqlConnection(ModConn.GetConn)
Dim mySelectQuery As String = "Backup database popcrm to DISK ='" & BackupDataName & "'"
Dim myReader As SqlClient.SqlDataReader
Dim Cmd As New SqlCommand(mySelectQuery, Conn)
If Conn.State = ConnectionState.Closed Then Conn.Open()
Try
Cmd.ExecuteNonQuery()
BackUpData = ""
Catch ExSQL As SqlException
If ExSQL.Number = 3201 Then
BackUpData = "请正确输入备份文件的存放路径！"
Else
BackUpData = ExSQL.Message
End If
Catch Ex As Exception
BackUpData = Ex.Message
End Try
Cmd.Connection.Close()
Cmd.Dispose()
Conn.Dispose()
End Function