在查询分析器里执行 uses master restore database name from disk='c:\name.bak' with replace在程序里用 adoquery执行用adoquery连接到master数据库 with adoquery do begin active:=false; sql.add('restore database name from disk='+'+''''+'c:\name.bak' +''''+with replace') execsql; end;
正如My_first(小@_@小) 所说 用 uses master restore 具体可查《SQL SERVER 2000开发指南》 第766页 Restore Database AppDta From Disk='c:\SQL2K\buckup\appdtaBkp.bak'
uses master
restore database name from disk='c:\name.bak' with replace在程序里用 adoquery执行用adoquery连接到master数据库
with adoquery do
begin
active:=false;
sql.add('restore database name from disk='+'+''''+'c:\name.bak' +''''+with replace')
execsql;
end;
uses master restore
具体可查《SQL SERVER 2000开发指南》 第766页
Restore Database AppDta From Disk='c:\SQL2K\buckup\appdtaBkp.bak'