<HTML>
<HEAD>
<TITLE>Backup with diagnose fail</TITLE>
</HEAD>
<BODY>
<FONT FACE="Verdana"><SPAN STYLE='font-size:12.0px'>Hello,<BR>
<BR>
According to the doc, we can send a sqlexecute command to the server to backup the database.<BR>
(<a href="http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:backup)">http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:vcomponents:vsql:reference:backup)</a><BR>
<BR>
This seems very useful as I can do a “hot” backup.<BR>
<BR>
If my SQL command is<BR>
BACKUP DATABASE TO absolute_path<BR>
all is working well.<BR>
<BR>
If I send<BR>
BACKUP DATABASE TO absolute_path WITH DIAGNOSE<BR>
nothing happen and I can see an error in the log file :<BR>
“ERROR 0x66503: Database "myDB.vdb" fails on diagnose”<BR>
<BR>
I’m working with V4RB v5.6 on MacOS X 10.6.8. The client and server are on the same machine, the server folder is in my Document folder and I do the backup in the Desktop folder.<BR>
The permissions of the server folder is : Me:RW, Staff:RW, Everyone:R<BR>
The permissions of the server app (vserver_x64) is : Me:RW, Staff:RW, Everyone:R<BR>
The permissions of the database folder is : Me:RW, Staff:R, Everyone:R<BR>
The permissions of the folder created by the server for the backup is : System:RW, Staff:R, Everyone:R<BR>
<BR>
And this raise a second question : I can see that the owner of the created backup folder is “System”, despite the fact that the owner of the server app is Me and that the owner of the parent folder (Desktop) is Me. Thus my client app cannot rename, move or delete this folder without admin right !<BR>
Is it the attended behavior ? I’m I doing something wrong ?<BR>
How am I supposed rename the backup folder or delete some old backup ?<BR>
<BR>
Thank you.<BR>
<BR>
François Van Lerberghe<BR>
Rue Thier Monty, 15 A<BR>
4570 Marchin<BR>
+32 (0)85 25 08 25<BR>
</SPAN></FONT>
</BODY>
</HTML>