Try sPath:=ExtractFilePath(application.ExeName)+'DataBack'+FormatDateTime('yyyymmddhhmmss',Now())+'.bak'; with ADOQuery1 do begin close; sql.Clear; ADOQuery1.SQL.Text:='use master BACKUP DATABASE Data to Disk = N'''+sPath+'''' ; ExecSQL; showmessage('备份成功!'); end; except showmessage('备份失败!'); end; 我备份语句是这么写的,我本想备份到程序所在目录\DataBack\,但每次都是备份到程序当前目录,文件名是这样的:DataBack20100827091820.bak
Try
sPath:=ExtractFilePath(application.ExeName)+'DataBack'+FormatDateTime('yyyymmddhhmmss',Now())+'.bak';
with ADOQuery1 do
begin
close;
sql.Clear;
ADOQuery1.SQL.Text:='use master BACKUP DATABASE Data to Disk = N'''+sPath+'''' ;
ExecSQL;
showmessage('备份成功!');
end;
except
showmessage('备份失败!');
end;
我备份语句是这么写的,我本想备份到程序所在目录\DataBack\,但每次都是备份到程序当前目录,文件名是这样的:DataBack20100827091820.bak
修改为
Path:=ExtractFilePath(application.ExeName)+'\DataBack'+FormatDateTime('yyyymmddhhmmss',Now())+'.bak'
修改为
Path:=ExtractFilePath(application.ExeName)+'DataBack\'+FormatDateTime('yyyymmddhhmmss',Now())+'.bak'上面得写错了,抱歉