Viewing 15 posts - 211 through 225 (of 338 total)
WayneS (3/27/2011)
And then the pages will be updated again with the "undo" operations for that transaction, and eventually flushed to disk again.
The log entries are still in the log file....
March 27, 2011 at 11:31 am
GilaMonster (3/25/2011)
SQL writes data modifications to data pages in the data cache. It writes the log records to disk at the point the transaction is committed (or sometimes before). At...
March 27, 2011 at 11:10 am
If I understand this correctly let me get this right in terms of cookie analogy.
The cookie plate is your physical log file.
The good cookies are your inactive VLF.
The bad cookies...
March 23, 2011 at 7:52 am
Thanks for the link muthukkumaran
Following is the extract from your blog which is your definition of truncation of log
SQL server run the CHECKPOINT truncates the inactive portion of the log...
March 23, 2011 at 4:33 am
Brandie Tarvin (3/22/2011)
You're welcome. I hope the analogy made things easier to understand for you.
Yes it was perfect.
Now I am much more clearer on the basics of log files than...
March 22, 2011 at 12:49 pm
GilaMonster (3/22/2011)
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Thanks for the link.
March 22, 2011 at 12:44 pm
You are misreading that entry. It says it truncates, not shrinks. Truncate allows SQL to reuse the portion of the log that was just freed. It's like eating the cookies...
March 22, 2011 at 12:38 pm
Brandie Tarvin (3/22/2011)
A checkpoint doesn't change the size of the log files. It just marks a section of the log as ready to be reused by the transaction log process....
March 22, 2011 at 12:29 pm
Ok Ok Ok.Now I got it.
Sorry for getting this all mixed up.I was expecting the same behavior both on log and the datafiles when shrinking with these 2 options.
One last...
March 22, 2011 at 12:22 pm
GilaMonster (3/22/2011)
Sachin Nandanwar (3/22/2011)
Do shrinking of database logged even though the recovery model is SIMPLE ?All data modifications are logged regardless of the recovery model.
So when a checkpoint occurs the...
March 22, 2011 at 12:11 pm
Ok now I understood.
I thought that truncateonly when used with shrink command for log files releases the inactive VLF's which are at the end of the log file to the...
March 22, 2011 at 12:03 pm
Hey Brandie,
I do agree that changing from FULL to SIMPLE will break the log chain but just wanted to highlight the fact that OP had mentioned that his/her recovery model...
March 22, 2011 at 11:44 am
Yes sorry I should had rephrased my statement to "TruncateOnly no longer supported with log backups'.
But with the definitions you provided does not seem to be exactly doing the same...
March 22, 2011 at 11:29 am
muthukkumaran (3/22/2011)
mail.pnreddy (3/21/2011)
Here are the steps i followed.
Change the DB back to Simple If it is in Full mode.
Change it back to Full mode.
Use T-sql...
March 22, 2011 at 11:06 am
GilaMonster (3/20/2011)
Marios Philippopoulos (3/19/2011)
Can you elaborate on the latter two? "table parameters or cached temp table shells".
For table-type parameters see Books Online.
Since 2005 SQL can cache temp tables that are...
March 21, 2011 at 5:16 am
Viewing 15 posts - 211 through 225 (of 338 total)