July 10, 2018 at 12:46 pm
I know this is basic, but I'm having trouble understanding the MSDN articles and forum discussions on this. If a database is in simple recovery does the log file only get truncated after a backup is taken (or someone attempts to directly reduce the log)? Again, I apologize for such a basic question I just can't seem to nail down how the log works in relation to simple recovery.
July 10, 2018 at 12:49 pm
DataAnalyst011 - Tuesday, July 10, 2018 12:46 PMI know this is basic, but I'm having trouble understanding the MSDN articles and forum discussions on this. If a database is in simple recovery does the log file only get truncated after a backup is taken (or someone attempts to directly reduce the log)? Again, I apologize for such a basic question I just can't seem to nail down how the log works in relation to simple recovery.
In the SIMPLE recovery model the transaction log is truncated on CHECKPOINT. This usually occurs after a transaction commit or rollback (implicit or explicit). If it doesn't you would need to check sys.databases to see why it didn't.
July 10, 2018 at 12:53 pm
Perfect, thanks a ton!
July 12, 2018 at 1:50 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply