restore question
Posted in 2000
I am running Informix 7.24 and I have a question for anyone who can answer it I have been backing up my production server and restoring it on my backup system once a week for about 6 months. This past weekend I tried to restore but the restore never finished. It normally runs for 4 1/2 hours. I let it run for 8 hours the first time and 11 hours the second before I broke out of it. The interesting part is I CAN bring the system online and the only problem I have had is an assert failed on 1 index (Which I dropped and recreated). This is our backup server so the importance of this particular data being perfect is not the most important issue. The questions I have is: What could be the reasons that the restore never finished? (One clue is that it was waiting on a checkpoint( CHKPT BLOCKED ) & how can I correct this for my next restore next week? How clean is the data? I know this is an impossible question to answer but I would like opinions. I don't know what further information you might need but I will provide any more information that might help. Thanks, Howard Rock mailto:hrock@iso.com visit our website at http://www.iso.com