Question on Simple Recovery Model

Question

Question on Simple Recovery Model

coolchaitu

SSChampion

Points: 10334
More actions
October 27, 2016 at 10:29 am

#400948

Good morning Experts,
In the Simple recovery model, are the tlogs truncated on checkpoint or physically shrinked? Does Log truncation mean physical shrinking of log file?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

coolchaitu (10/27/2016)
Good morning Experts,
In the Simple recovery model, are the tlogs truncated on checkpoint or physically shrinked? Does Log truncation mean physical shrinking of log file?

The log entries are marked as available for reuse when the checkpoint fires. Space is not yielded back to the operating system.

Shrinking is a different operation. You generally don't want to shrink your log files, but like so many other generalities, there are exceptions. In short, it depends.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 2

The question you ask is one of "those" questions with a whole lot of tentacles, especially if your in need of doing something in particular using that recovery model. I strongly recommend that you ask Yabingooglehoo about the SIMPLE Recovery Model and learn more about it rather than just taking an answer that covers only a tiny facet of the Recovery Model.

Seriously, the data you save may be your own. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

BLOB EATER SSChampion Points: 14609 More actions · Answer 3

As Jeff said, I would get a coffee and enjoy reading this:

https://technet.microsoft.com/en-us/library/2009.02.logging.aspx#id0060077

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 4

BLOB EATER (10/28/2016)
As Jeff said, I would get a coffee and enjoy reading this:
https://technet.microsoft.com/en-us/library/2009.02.logging.aspx#id0060077

I would also get several coffees and a sandwich, and read Tony Davis & Gail Shaw on Transaction Log Management: https://www.red-gate.com/library/sql-server-transaction-log-management. (Free PDF from Redgate, and available as a physical / kindle book from Amazon...)

Thomas Rushton
blog: https://thelonedba.wordpress.com