unit1.pas

数据库恢复与备份 数据库恢复与备份 数据库恢复与备份

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls;

type
  TForm1 = class(TForm)
    Button1: TButton;
    ADOCommand1: TADOCommand;
    ADOConnection1: TADOConnection;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
adocommand1.CommandText:='backup database st to disk=N''f:\st.bak''';
adocommand1.Execute;
//BACKUP DATABASE [数据库名] TO DISK = N‘F:\data\数据库备份‘ WITH NOINIT , NOUNLOAD , NAME = N‘ 数据库 备份‘, NOSKIP , STATS = 10, NOFORMAT注意：需要修改的地方，数据库名，DISK＝（这里需要填写路径和你的数据库备份的名
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
adoconnection1.Close;
ADOCommand1.CommandText:='use Master';
ADOCommand1.Execute;
adocommand1.CommandText:='RESTORE DATABASE st FROM DISK=''f:\st.bak'' WITH RECOVERY';
adocommand1.Execute;
ShowMessage('数据库还原成功!');
Try
ADOConnection1.Connected:=True;
Except
ShowMessage('无法重新接连数据库!,系统即将退出!');
Application.Terminate;
End;
end;

end.