请教: ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:='restore database test from ''backup3''';
try
ADOQuery1.ExecSQL;
showmessage('成功');
except
showmessage('失败');
end;
我单击 button 按钮时提示:
backup3 附件有错误, backup3 是一个备份设备!
(已经备份了 test 数据库)各位大哥,我是错在哪里啊?谢谢!
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text:='restore database test from ''backup3''';
try
ADOQuery1.ExecSQL;
showmessage('成功');
except
showmessage('失败');
end;
我单击 button 按钮时提示:
backup3 附件有错误, backup3 是一个备份设备!
(已经备份了 test 数据库)各位大哥,我是错在哪里啊?谢谢!
ADOQuery1.SQL.Text:='restore database test from ''backup3''';
改成
ADOQuery1.SQL.Text:='restore database test from backup3';
试试
RESTORE DATABASE [test] FROM DISK = N'D:\MSSQL\BACKUP\1'最好加上绝对路径