what does checkpoint do in simple mode?

Posted on 2014-08-26
Medium Priority
Last Modified: 2014-09-08
database is in full mode.
 change it to simple
 run the command 'CHECKPOINT'
 change it back to full.
 what has happened in this process?
Question by:25112
  • 2
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 40285732
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.

Author Comment

ID: 40287636
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?
LVL 53

Accepted Solution

Vitor Montalvão earned 2000 total points
ID: 40287652
What you mean with "regenerate the log file"?

If means empty the log file, then the answer is yes but be careful because you might loose information and your backup chain will break, that's why you need to run a full backup after set it back to full recovery model so you can start a new backup chain.

But you have a better option that is running transaction log backups. It's the correct and the faster way to do it.


Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Screencast - Getting to Know the Pipeline
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question