Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

what does checkpoint do in simple mode?

database is in full mode.
 change it to simple
 run the command 'CHECKPOINT'
 change it back to full.
 
 what has happened in this process?
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Since you just changed the recovery model to simple I would say that you won't loose nothing. But you can check that by the time that it's need to set the recovery model to full again.

And don't forget to make a full backup immediately after went back to full recovery model.
Avatar of 25112
25112

ASKER

the above steps was recommended to 'regenerate the log file' which was corrupted.. hence I was trying to understand how checkpoint can do that?

if I just do
---
database is in full mode.
  change it to simple
  change it back to full.
---
it won't regenerate the log file, will it?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial