请问各位怎么样才能做到数据库的还原我的代码是这样的:
with adoquery1 do
begin
Close;
SQL.Clear; //cpxsgl为数据库名
SQL.Add('alter database cpxsgl set offline with rollback immediate');
//切断数据库连接使程序独占
ExecSQL;
Close;
SQL.clear; //edit1控件存放选择还原路径
SQL.Add('restore database cpxsgl from disk='''+edit1.Text +'''with replace');
//还原数据库语句
adoquery1.ExecSQL;
end
with adoquery1 do
begin
Close;
SQL.Clear; //cpxsgl为数据库名
SQL.Add('alter database cpxsgl set offline with rollback immediate');
//切断数据库连接使程序独占
ExecSQL;
Close;
SQL.clear; //edit1控件存放选择还原路径
SQL.Add('restore database cpxsgl from disk='''+edit1.Text +'''with replace');
//还原数据库语句
adoquery1.ExecSQL;
end
begin
Close;
SQL.clear;
SQL.Add('use master');
SQL.Add('restore database cpxsgl from disk='''+edit1.Text +'''with replace');
//还原数据库语句
adoquery1.ExecSQL;
试试行不?