Subject | Re: [IBO] Re: TIBOBackupService and TIBORestoreService |
---|---|
Author | Robert Martin |
Post date | 2018-05-14T01:37:27Z |
Hi Mikey
The path listed looks like it is missing the server name at the staff yours shows ': c:\mysoft\dagdb\mybackup.gbk' I would have expected something like 'MYCOMPUTERNAME: c:\mysoft\dagdb\mybackup.gbk'. Are you sure you have correctly specified the server name?
Here is some of my old code that does a backup, note this displays the progress in a memo.
with IBOBackupService do begin
ServerName := DBServer;
LoginPrompt := False;
Params.Clear;
Params.Add('user_name=' + WS_DB_USERNAME);
Params.Add('password=' + WS_DB_PASSWORD);
Active := True;
try
try
Verbose := True;
Options := [IgnoreLimbo];
DatabaseName := SourceDatabase;
BackupFile.Clear;
BackupFile.Add(DestBackupName);
SQLMemo.Clear;
Application.ProcessMessages;
ServiceStart;
while (Eof = False) do begin
SQLMemo.Lines.Add(GetNextLine);
Application.ProcessMessages;
end;
except
on e : exception do begin
MessageDlg(ErrorMessageText + #13#13 + e.Message, mtInformation, [mbOk], 0);
Result := False;
end;
end;
finally
Active := False;
end;
end;
Cheers
Rob
The path listed looks like it is missing the server name at the staff yours shows ': c:\mysoft\dagdb\mybackup.gbk' I would have expected something like 'MYCOMPUTERNAME: c:\mysoft\dagdb\mybackup.gbk'. Are you sure you have correctly specified the server name?
Here is some of my old code that does a backup, note this displays the progress in a memo.
with IBOBackupService do begin
ServerName := DBServer;
LoginPrompt := False;
Params.Clear;
Params.Add('user_name=' + WS_DB_USERNAME);
Params.Add('password=' + WS_DB_PASSWORD);
Active := True;
try
try
Verbose := True;
Options := [IgnoreLimbo];
DatabaseName := SourceDatabase;
BackupFile.Clear;
BackupFile.Add(DestBackupName);
SQLMemo.Clear;
Application.ProcessMessages;
ServiceStart;
while (Eof = False) do begin
SQLMemo.Lines.Add(GetNextLine);
Application.ProcessMessages;
end;
except
on e : exception do begin
MessageDlg(ErrorMessageText + #13#13 + e.Message, mtInformation, [mbOk], 0);
Result := False;
end;
end;
finally
Active := False;
end;
end;
Cheers
Rob
On 12/05/2018 2:14 AM, mlcvista@... [IBObjects] wrote:
Hello Jason,
I've succeded at 80%...I've replaced in params my instructions by those ones :
user_name=SYSDBA
password=masterkey
Now I've got this message :"Size specification either missing or incorrect for file : c:\mysoft\dagdb\mybackup.gbk"
Where can I enter this size , please ?
With best regards,Mikey