Hi, I just recovered a database with: db_activate RECOVER FULLBAKCUP recover_start ARCH LOG 740 recover_replace ... .... recover_ignore util_release db_online
I now want to switch on autologging autlog_on ARCH but I get an error message: ERR -24988,ERR_SQL: sql error -126,Databackup missing (Backuphistory lost) It only seems to work if I make a complete backup first. This is somewhat annoying to do because: a) the backup is big. b) This system is a copy of production system that get synchronised every night with the added complexity that during the day changes are made to that copy database So every night I reintialize the database, import the fullbackup plus all additional archived logs created on production ever since. If, additionally, I need to create a complete backup of that freshly installed copy, before I'm able to switch on autologging, it will take very long to run the entire process. In the documentation I could not exactly find that a fullbackup is needed before you can switch on autologging. This leads me to suggest I am missing something, but I don't know what. Who does or who can point me to the relevant information? Thanx in advance, Regards, Filip Sergeys -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
