Dim Con,Strcon
Set Con = Server.CreateObject("ADODB.Connection")
Strcon = "driver={SQL Server};"&"server=ASUKA;uid=sa;pwd=65012514;database=master"
Con.Open Strcon
.......
dim sql
sql="declare hcforeach cursor global for select 'kill '+rtrim(spid) from master.dbo.
sysprocesses where dbid=db_id('travel') exec sp_msforeach_worker '?' "
con.execute sql
sql="RESTORE database travel from disk='"&server.mappath("backup")&"\"&"
backdb.dat"&"'"
con.Execute sql
出现这个错误
[Microsoft][ODBC SQL Server Driver][SQL Server]先前的还原操作未指定 WITH NORECOVERY 或 WITH STANDBY。请在除最后步骤之外的所有其它步骤中指定 WITH NORECOVERY 或 WITH STANDBY 后,重新启动该还原序列。