lulon
asked on
is a checkpoint needed before doing shutdown of Sybase?
Hello,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.