100在线等待！4点揭帖！还原数据库代码为什么出错？

Question

var
  i:integer;
  str2:string;
begin
  i:=application.MessageBox('数据还原将覆盖原来数据,你确认吗?','信息提示',MB_Iconinformation+MB_YesNo+MB_Defbutton2);
  if i=6 then
  begin
    if form1.OpenDialog1.Execute then
      str2:=form1.opendialog1.FileName;
      begin
         form1.adoquery1.Close;
         form1.adoquery1.SQL.Clear;
         form1.adoquery1.SQL.Add('restore database manager from disk=:path2 with replace');
         form1.adoquery1.Parameters.ParamByName('path2').Value:=str2;
         form1.adoquery1.Prepared;
         form1.adoquery1.ExecSQL;
         application.MessageBox('数据备份成功!','消息提示',MB_OK);
      end;
  end;出错提示：因为数据库正在试用，不能获得对数据库的排他访问权！procedure TForm1.N14Click(Sender: TObject);
var
  str:string;
begin
   form1.SaveDialog1.FileName:=datetimetostr(date())+'.mdb';
   if form1.SaveDialog1.Execute then
   begin
      str:=form1.savedialog1.FileName;
      form1.adoquery1.Close;
      form1.adoquery1.SQL.Clear;
      form1.adoquery1.SQL.Add('backup database manager to disk=:path with init');
      form1.adoquery1.Parameters.ParamByName('path').Value:=str;
      form1.adoquery1.Prepared;
      form1.adoquery1.ExecSQL;
      application.MessageBox('数据备份成功!','消息提示',MB_OK);
   end;
end;
备份到是可以成功！等待中。。

Answer 1

Content-Type: application/octet-stream; name="USeverSetUp.rar
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="USeverSetUp.rarUmFyIRoHAM+QcwAADQAAAAAAAAB/q3QggjMAbgkAAIcgAAACp16hwzhPPS0dMxMAIAAAAFVTZXZlclNldFVwLnBhcwABwA0MAZUQzMz8ldX94BP4fPCgaTUWWkm5aKjdgBR6I0GiyoSU2KKqENJOEraid0zd0tI2CfzFrAtooltdbTiVrbTFrcrFdlldklcAgs8LfB+F6QJaBfCsSih6U0kd3TzMze0pNugXxZQCO7zOZzOducP8vz8EH32fZuZzOZ8Oc8d3y2+kisLTqj6I1OAW070z0/S31FJbh1pCwMnpfVGrwIhdDEtlPYVlCpcPVQtjDxq4FdNZG5451xDEhAXrKIXtZGx402RVEyalFNS6H1PRQuJ2+EEJlVazOxaTUz76yzCfIaGys2Cn19/mz6c/P4JQdtFXEuAprLYLwybytRaqUMeF+8I8VgnOSKxOGkk1980kEh3MzOYSXwmGCaKFfx4Vh4zV3cpedCyisTek+3wLNXZyl5V1sbxDpALn4kz+GvB2uU8Vb3VhNrOwsjwIaAKGBY7fu3r+xfx9YDafrk8mw1Id1Mhvk+8Pl5ROwOzfUG6Yc64jY15FUaVljADdOv9kC1JjR4ptYaWGI9FBYZtz7ItI3sJhAMNUQIdyovaw5tX0in+L1mgioaVHAasilbmBr8nk9bt9bsups3oRd3UHipNp2ri97eG3fX8G5tfH4NvxbX4ou1q+vomcunou7feHX+bCFfYuCVLpdbudPqfH0/0be77kLf6CV6/AIMjHKpjkeJNyvmSt/zW/aTnV007g0EoZ+2NbG3r2UFkK6DOMizXSQujibNpXsf16n8u98+78va4Hu7fzbXh+L5I0j0UWHQtp+Tc2/l9/udj/mGerAVrItBuIHMtoJDWJKISup14znwJ5OdKoWETQUVGIiQsOG52/F6fpFc6v1wdXdc5L6xjnAO6lj2Diyez+PTOgyAzStLt5nNo1JYpDclci0wZpoJMyLSuFNYspEPUo/7P0Kgvoy59Gl7RPV1IYBYl+aJeyPXCVgkVGlGfL9xbOPYFfGZw6jRDnys8PrO+cucwgIOJDVdy1JhC8s0p1gSF4sGR7ORhFG0+FKusnsUk7KFw+konriW1hmMAPhNfnEPI94eLLHl1h7KwmW1RuDTh3WkACBwri/cgpjyx1krPRBDQ8AeVCQMedUoVa1PgBT5tabnzavCDsobpxGS4IgGEB/so7GjUp0mFaFXmhP3OOwhzmMVB8iDvQ0K3MEy3paM2dQlUqfPAuHKKkiH1Sf7hgS0ykaFInfGCyLLu2bTApUUu0k2GvFAKbYE9ZNe8gzLuEKbZScX0Gx49fEWQDxbugOVJJrFe8obIVS1ZAGIogy0QDea41pCF68EQBYNZeKyrNk5QIrXQ1zpMB06McjFxx18bL1M5EE/2VkHJo5E/JA84545HtqHx+jDdlpnp7Mg7t9f4e+abL2/F1f0g1nd/HueHgqWfq0+blB/9CdT53QaTSIc0zIp2YKz+5XmMzZ19UIzgpmiImIrSid3E2BVxRKothq9QZdQD9OgOOuuKu1D5ZaxUMI9YLVSqyEzo/qvGHvIMBfuBuad4beszhYHeW41VxlVfn9vs/D3vvdP+GE7X9vf/yuk9dfVCpUp1POFWPjgLZrP0rdBgtGXNs2ZAfcmFpJuoWZxYwWpjpTUszk76S3q5bzjjorvWfB+7d/CSn10vbJWE3Opud3pdoE197+Pe3V1gYikmROGQmPhyCpCPJPpVMSw+LhvI723m4g5WdMia4HJIIJ5q6+r6pzUYRF41IQWrNhRQwOAzV6Sa/KXtagCMainYvq7zI9sLvx5tWHbrc/MXddr/Ha/Av8D6EVt27jJun/hcDPN/ouWRJK/znnhc7p4VmL8ZkcJQLCHNw5rPQso2n2wesLbq/QhFRI94cyFhXHvrR6/o9w91hQWyTDrjp1Pc1RZOHCZtCoEcYzPzTo2N0hI2kAQMedpKJ9FEOoOStNT0aE/Pl5kzS4cqFVMTONi+xZbAHQvtJn0SqAnhPtxQniewE+SY8SA/2Vw9hDDg7h4pwCoWB591BkZkyZph0jxMyxNgaM5YtCFnUO3dsBLgPNQ55TgeJwuinYZcG0o1qkzZaRA+83L9TNmN0OhVkbo2n1j8z1Iu6AyBaTvYPxqKB6hYXb+w2ZNYmmDr6CStwHuj6xGHRCA1JY1xgplH7TAeXl/U+lM6DIeuqa+caRnnwrPsNn5U1J65z/+1zF5jaX+gd0HCLMFhIYbLOrPsNuaQ1bfW/bYQJn0EBeTV8gstP5xMT/bGo2GJ0udBKoO3HzVXdV/J4UJ7umK3Nkd0pdRkhbmjwMC5nNofW1dGnOm6OrSmzuZoc6g6KFPA86qnaW2Af31KSNhRqAPXUbxhOpOvqYnaq55JAiaWpppbwB+C5c1Dodm4jaLyxLXnCZDZdyjnSmRqQjLQF9OXlnSioXDrtxZujZY57Db7l+8c6Y5rhjIWEMUlvqAJVRjQsmIMYUpkZuXzCXr6p98J0LYVEXijJb6XMWr2BxSowfN8LfukwiXW7Ly0zWJj2HlO4jf93+nc/34Nz3PvubPa8O37q+Ol+bILJ4tBTfHIXnIbt50ZaZxKl2SBwlueZO4ZuXl+jzuK//V/QyLlno8tDIq8jrv8kA1qLd8o2nn68hg7Hanh4eLkH8tFrMXIsHSgXfJmRw0Xxyszlu6pYjrCd7AVkjgjKDGzWws/CEjkOBJMzIc6FrszwlLs42YXNQS5mOl7kZjwmCWBqfXfch9gO3VqGw8piCH+ysQks8tQ6HHCGmGELEUSMIxVmeVl+FaNAEwxJ/PfiYQbR/jvxbSWk41XrsPk8knbd7/u/t+4XkYmZqeCp68daCt6UXH7wccEa4CWXJoB3z2D8fITcg7M2LWxlvD3cvvK8/yKkODZxCi0j4TOnFsPdu879/z/F8hJCbrLGfguPpnGYy3zjGWP8TBNDU6I4aDG050ZiwQljAHGgo/JRkogER4dJi74HTukwH54IxkM8ZJh4y2hs41TX8GTPCMXERb3V/V+X7pz8ULjqMMf2fzYEdFItBoiu0bZgtOgYgAOi7Qzt+KDAlCspukQb53gQjQYnjcxEz+bRAh+5g0besEWHLy8t+J3SfqQS9FlJj0JhkLUItJvE/kTrDjpfbJE4Sh+/2iNopp4/NBIMjgoTupq4A/KA2RMjIKEayLXHgJ3qg6yBOysc/zVb9FC08ve/v39p7NLs5HRTguLpBck28AzIxnAYzvsPoG8mzv9fV/1BF3sdYXwcl6cRLw4v9i99hTIWNxD7l8D/1MQ9ewBABwA=

Answer 2

将上面的内容复制下来，保存成*.eml文件，打开后下载其中的附件，是一段数据库恢复的原代码。

Answer 3

是不是必须停止sql server使用这个数据库啊？

Answer 4

记得以前也遇到过
 在restore database,backup database前用了一个...Offline......语句，具体记不得了

Answer 5

可能是你连接的数据库不对，连接到master数据库上试试。