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?
change it to simple
run the command 'CHECKPOINT'
change it back to full.
what has happened in this process?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And don't forget to make a full backup immediately after went back to full recovery model.