Re: What happens if logical logs are full

ber@knapp.knapp.at (Erwin Burgstaller) wrote: >Maybe a former question was to complex. Now I'm asking only: >Is it possible to recover from full logical logs, with almost no loss of >data? Hi Erwin, It depends on whether the logs were filled due to a long transaction that spanned all logs, or you just have not backed up your logs. In the second case all you need to do is go to screen and back up the logs. In the first case it basically restore from archive. If anyone out there knows a another way to recover from a long transaction that fills log I would love to hear from you. >thanks >Erwin >-- >============================================================================= > Erwin Burgstaller |-| KNAPP Logistics Automation > . |-| Guenther Knapp Strasse 5-7 > Internet: ber@knapp.co.at |-| A-8075 Hart bei Graz > Voice: +43 316/495-618 |-| Austria >\\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ \\___/ >----------------------------------------------------------------------------- gordonh@acslink.net.au RIPLEY, Queensland, Australia