is a checkpoint needed before doing shutdown of Sybase?
Posted on 2010-03-30
I have the following doubt for the Sybase experts:
Do you recommend to do a checkpoint of all databases before doing a shutdown of Sybase?
If one of the databases goes to recovery mode after start Sybase again and the checkpoint wasn't done, then you lose the transactions that were not written to disk, right? It will also take more time to finish the recovery since it has to undo all the transactions found in the memory, am I right?
Thanks in advance