Re: Transaction log files in a SE database

Sally Woolrich <Sally@excelsis.demon.co.uk> wrote: >In article <43i4r4$9cm@centaur.achilles.net> > dean@achilles.net "Dean Steptoe" writes: ><snip> >> We tried to roll-forward the database using the logfile, but it DID NOT work. <chop> >ii) Not clearing the transaction log down in line with the backup > process. It is vital that the backup is taken with no-one > altering the database, and that the transaction log is > immediatly cleared down. That was the part reason the rollforward did not work. The way the database was trashed created a lot of unique situations. One of them was that there was no backup of the latest information, except what was in the transaction log. We restored the database up until the point of the crash (the last backup), and still the transaction log, which was not cleared during the last backup. That was part of the problem. Dean.