You are not logged in.

Restoring Data

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Jody.Innes

Intermediate

  • "Jody.Innes" is female
  • "Jody.Innes" started this thread

Posts: 5

Date of registration: Aug 20th 2010

Location: United Kingdom

Occupation: Accountant

Hobbies: Sailing

  • Send private message

1

Tuesday, June 28th 2011, 2:43pm

Restoring Data

Hi,

I have set up my PALO database about 6 mths ago and all fine. Ran a report this morning to find that most of the data had been deleted. I can't think how as only I am using it at the moment. Although had asked our IT dept to add some new users last week - could be coincidental.

I do not have the rights to start & stop the Palo server so I have do idea if this ever happens. If it has never been stopped & started does this mean I have no way of restoring the data?

We do take backups of our entire IT server daily so I am sure I can get a copy of the database as it was but from what I remember when setting Palo up it won't recognise it when I copy it in unless the services where stopped before the copy was made.

Please help - I am pretty desperate here.

Aisakos

Sage

  • "Aisakos" is male

Posts: 82

Date of registration: Aug 9th 2006

Location: Berlin

  • Send private message

2

Friday, July 1st 2011, 2:57pm

Hi,
so far as I understand all the data you are importing are at first in the log oder archive-files. When the server is stopped, the whole data is written into the csv-files.
Of course there is a automatically backup of the server-data.
But this is a trap: You only can use the csv-files for a backup, but if these data are not written in the csv-files, because the server has crashed or hase stopped because of a failure, you have no chance to get the old data: Maybe I am wrong, but I have found no way the get the data out of the log or archive-files. But if somybody knows a method, it would be great!! I lost my data one one year in a similar way. Now the IT-department has programmed, that the server stops every night and restart automatically, in this case the data are in the csv-files and secure.
Best regards
Roland

Jody.Innes

Intermediate

  • "Jody.Innes" is female
  • "Jody.Innes" started this thread

Posts: 5

Date of registration: Aug 20th 2010

Location: United Kingdom

Occupation: Accountant

Hobbies: Sailing

  • Send private message

3

Saturday, July 2nd 2011, 2:22pm

Thanks Roland. Do you know what happens if you set up the autosave line in the .ini file? Does this write the data from the log file to the csv file? Our IT support aren't very supportive! I don't think they will agree to stop and start the server daily based on their initial reaction

Aisakos

Sage

  • "Aisakos" is male

Posts: 82

Date of registration: Aug 9th 2006

Location: Berlin

  • Send private message

4

Monday, July 4th 2011, 9:47am

Hi,
please look at: http://www.jedox.com/community/palo-foru…er+Service+with
there are also many hints by searching for "backup". My IT-Detapartment have programmed something in this direction. I don´t know exactly. Maybe your IT-Department will know what to do if you give them some hints. I hope!
Best regards
Roland
Rate this thread