有关SQL数据库恢复语句的疑问?
我用SQL语句恢复SQL数据库的备份,代码如下:
Private Sub restoredb()
Dim cn As New ADODB.Connection
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Data Source=" & computername
Dim restorestr As String
restorestr = "RESTORE DATABASE try FROM DISK = 'c:\mssql7\backup\a。bak' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY"
cn.Execute (restorestr)
end sub
如果我想把要恢复为的数据库(该例中是a)以及恢复文件的路径名都作为变量,应该如何作,请给出例子,我试了好久,老出错,没信心了!