Re: Transaction log files in a SE database

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. I have found a number of things which can stop this being able to work (in SE): i) Not clearing out the '.dbs' directory before restoring the database from backup. The rollforwards may try to create temp tables in here which already exist. 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. Have you found more ways of stoppin 'ROLLFORWARDS' working? Please tell! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================