Set recovery model to full. What to do with existing log (.ldf) files?

A consultant changed the recovery model from full to simple for our production SQL databases.  I would like to set the recovery model back to full.  However, the log files (.ldf) have a date/time which is the same as the .mdf files.  I'm not sure what to do with the log files.  Should I delete them or leave them alone?  I wonder why the log files have the same date/time as the the .mdf files if the recovery model is set to simple?  Thank you.Screenshot of date/time for mdf and ldf files
davidrobertbristowAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Instead, simply change the mode back to FULL and take a full database backup as soon as you can.  Then start taking regular log backups again, as you would any time a db is in FULL recovery model.  That's all you need to do, nothing extra/special.
0
 
Scott PletcherSenior DBACommented:
DON'T EVER DELETE LOG FILES!

Log files are still needed, even in simple mode.
0
 
davidrobertbristowAuthor Commented:
Can I change the recovery model back to full during production or does it need to be done off-hours?
0
 
Scott PletcherSenior DBACommented:
You can do it any time.  

But it won't actually provide any additional recovery possibilities until you've taken a full db backup.  That is, the point of full recovery mode is to allow you to recover changes lost if the db fails; the log file is used "forward recover" (as it's called), i.e. reapply data, to the db.  

But you can't use the log to forward recover until you have a full db backup from which to work.  And a full backup made when in SIMPLE recovery mode won't work.  You have to have a full backup made after the db was put back into full mode to use as a valid starting recovery point.
0
 
davidrobertbristowAuthor Commented:
I understand.  Set the recovery mode to full.  Then, take a full DB backup to start the log file chain.  Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.