SQL Sever Trans Log

Posted At : June 2, 2008 4:36 PM | Posted By : Adam Crump
Related Categories: MS SQL Server 2005

I am attending a SQL Server 2005 class, and have already learned a few new things. First of which is what SQL server does when you execute T-SQL commands. I would presume that it takes the command, interprets it and then persists the data to memory, writes the trans log, and eventually persist the memory to disk. Well this is not the case! From what I understand, the first thing it does after interpreting the commands, is write the instruction set to the transaction log. it then plays the transaction log back to apply to the db in memory. The last step would be to persist the in memory db to disk. This is pretty neat to know and kinda makes sense. The trans log is used for point in time recovery thus it makes perfect sense to write to this first. Another reason this is important information to know is because it has an impact on how you would setup a certain kinda of trigger (more on that later). This peek into how SQL server works under the hood is good to know, as all sorts of things make sense now. This explains several aspects of database maintenance planning and the importance of the trans log. Before I thought it was a simple standard log of what went on. Now I understand that the trans log is the actual working file for SQL Server. The trans log is basically a recorded macro file. This means that you can do "playback" from the trans log thus its importance in point in time recovery. Cool stuff!!

Comments (16) | Print | Send | 2264 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
[url=http://www.topowerleveling.com]world of warcraft power leveling[/url] [url=http://www.topowerleveling.com]wow power leveling[/url] [url=http://www.topowerleveling.com]power leveling[/url] [url=http://www.gowowpowerleveling.com]wow gold[/url] [url=http://www.ac021.com]????[/url] [url=http://www.paper-cup-machine.com]paper cup machine[/url] [url=http://www.liandaauto.com/main.asp]Mass air flow[/url] [url=http://www.pabx365.com]?????[/url] [url=http://www.mystery.net.cn/index/index.php]????[/url] [url=http://www.mystery.net.cn]????[/url] [url=http://www.mystery.net.cn]???[/url] [url=http://www.zhongke-china.com/product.asp" target="_blank">http://www.zhongke-china.com/product.asp]automatic rigid box line[/url] [url=http://www.zhongke-china.com/product.asp" target="_blank">http://www.zhongke-china.com/product.asp]paper converting and wrapping machines[/url] [url=http://www.zhongke-china.com/product.asp" target="_blank">http://www.zhongke-china.com/product.asp]automatic box makers[/url] [url=http://www.zhongke-china.com/about.asp]rigid set-up gift box[/url],[url=http://www.zhongke-china.com/about.asp]paperboard converting equipment[/url]


[url=http://www.lszwjx.com]????[/url] [url=http://www.lszwjx.com]?????[/url] [url=http://www.lszwjx.com]????[/url] [url=http://www.lszwjx.com/about.htm" target="_blank">http://www.lszwjx.com/about.htm]?????[/url] [url=http://www.lszwjx.com/about.htm" target="_blank">http://www.lszwjx.com/about.htm]?????[/url] [url=http://www.lszwjx.com/news.htm" target="_blank">http://www.lszwjx.com/news.htm]????[/url] [url=http://www.lszwjx.com/news.htm" target="_blank">http://www.lszwjx.com/news.htm]????[/url] [url=http://www.lszwjx.com/product.htm" target="_blank">http://www.lszwjx.com/product.htm]????[/url] [url=http://www.lszwjx.com/product2.htm" target="_blank">http://www.lszwjx.com/product2.htm]?????[/url] [url=http://www.lszwjx.com/plist493.htm" target="_blank">http://www.lszwjx.com/plist493.htm]?????[/url] [url=http://www.lszwjx.com/product2.htm" target="_blank">http://www.lszwjx.com/product2.htm]?????[/url] [url=http://www.lszwjx.com/plist490.htm" target="_blank">http://www.lszwjx.com/plist490.htm]?????[/url] [url=http://www.lszwjx.com/product2.htm" target="_blank">http://www.lszwjx.com/product2.htm]?????[/url] [url=http://www.lszwjx.com/plist495.htm" target="_blank">http://www.lszwjx.com/plist495.htm]?????[/url] [url=http://www.ruian2machine.cn]???[/url] [url=http://www.ruian2machine.cn]?????[/url] [url=http://www.ruian2machine.cn]?????[/url] [url=http://www.plastic-thermoforming-machine.com/product.htm]thermoforming Equipment[/url] [url=http://www.packagemachinery.cn]bag making machine[/url] [url=http://www.todesign.com.cn]????[/url] [url=http://www.todesign.com.cn]????[/url] [url=http://www.tzonegroup.cn]??[/url] [url=http://www.tzonegroup.cn/about.asp]??????[/url] [url=http://www.tzonegroup.cn/products.asp" target="_blank">http://www.tzonegroup.cn/products.asp]???[/url] [url=http://www.rajayj.cn]???[/url] [url=http://www.rajayj.cn]?????[/url] [url=http://www.ashuashi.com.cn]????[/url]


[url=http://www.gowowpowerleveling.com]power leveling[/url] [url=http://www.gowowpowerleveling.com]wow power leveling[/url] [url=http://www.zhongke-china.com]paper box[/url] [url=http://www.zhongke-china.com/about.asp]paper box equipment[/url] [url=http://www.plastic-thermoforming-machine.com]thermoforming Equipment[/url] [url=http://www.plastic-thermoforming-machine.com]Plastic Machinery[/url] [url=http://www.plastic-thermoforming-machine.com/about.htm" target="_blank">http://www.plastic-thermoforming-machine.com/about...]Plastic Machine[/url] [url=http://www.wzbtjx.cn]??[/url] [url=http://www.wzbtjx.cn]????[/url] [url=http://www.wzbtjx.cn]???[/url]
# Posted By ccc | 7/29/09 2:49 AM
They had joined[b][url=http://www.game4power.com/]Buy Wow Gold[/url][/b]the humans, elves, dwarves, and[url=http://www.game4power.com/buy-gold/][b]Buy Cheap Wow gold[/b][/url]dragons to decimate the demonic warriors and ghoulish beasts and push the[url=http://www.aocsale.com]aoc gold[/url] remnants back into [url=http://www.game4power.com/buy-gold/]wow gold cheap[/url]the hellish beyond. Thousands [url=http://www.vipwarhammergold.com]warhammer gold[/url]had perished, but the alternative…
The dragon mage snorted. In truth, [url=http://www.itemchannel.com]wow gold[/url]there had beenno alternative. Krasus waved [url=http://www.aion4gold.com]aion gold[/url]long, tapering fingers over the orb, summoning a vision of the orcs. The view[url=http://www.itemchannel.com]world of warcraft gold[/url]blurred momentarily, then revealed a mountainous, rocky [url=http://www.ppgold.com]wow gold cheap[/url]area further inland. A harsh land, but one still full of life and capable of [url=http://www.wowgoldone.com/]cheapest wow gold[/url]supporting the new colonists. Already, several stone [url=http://www.wowgoldone.com/][i]cheap wow gold[/i][/url]structures had risen in the main settlement, where the [url=http://www.vipaiongold.com]aion gold[/url]Warchief and one of[url=http://www.aionkina.com]aion kina[/url]the heroes of the war, Thrall, ruled. The high, rounded edifice [url=http://www.game4power.com/]Wow Gold [/url],[url=http://www.game4power.com/]www.game4power.com[/url]that served as his quarters was crude by the standards of any other race, but orcs had a propensity toward basics.[url=http://www.metin2sale.com/]metin2 yang [/url][url=http://www.cheapaion.com/]aion kina[/url]!
# Posted By cheap wow gold | 7/29/09 10:29 AM
<a href="http://www.game4power.com"><strong>Buy Wow gold</strong></a> and <a href="http://www.aion4gold.com">aion" target="_blank">http://www.aion4gold.com">aion gold</a>,come on ,<a href="http://www.itemchannel.com"> World of warcraft gold </a> ,<a href="http://www.metin2sale.com">metin2" target="_blank">http://www.metin2sale.com">metin2 yang</a> <a href="http://www.cheapaion.com">cheap" target="_blank">http://www.cheapaion.com">cheap aion kina</a>!
and[url=http://www.game4power.com]Buy Wow gold[/url] and [url=http://www.aion4gold.com] aion gold [/url] ,come on,[url=http://www.metin2sale.com]metin2 yang[/url],[url=http://www.itemchannel.com] World of warcraft gold [/url],[url=http://www.vipaiongold.com]buy aion gold[/url] and [url=http://www.cheapaion.com]cheap aion kina[/url]!
# Posted By wzz | 9/11/09 6:05 AM
I recently to visit your blog, reading, I very much enjoy, and above the content is great.
# Posted By cheap jordan shoes | 9/15/09 9:57 AM
<p>Welcome to Buy UGG Classic tall boot.</p>
<p><a href="http://www.llikeonline.com">http://www.lli...;
UGG Classic tall boots are all made of genuine sheepskin imported from Australia, which can keep your feet utmost soft and let your feet breathe freely. Fashion will show UGGs tall modernity at a certain time, change as long as the trend is going. However, <a href="http://www.llikeonline.com">UGG Classic tall</a> sale are unchangeable classic for their high quality and classic elements. </p>
<p><a href="www.allofshopping.com">http://www.allofsho...;
UGG Tall Boots is genuinely made from Australian lavish twin-faced merino sheepskin. High quality, genuine sheepskin with premium fleece absorbs moisture like people’s derm to optimize the inner circumstance and keeps your feet dry and comfortable. The molded EVA outsole is extremely flexible and ethereal, and it will make a pair of perfect daily boots. There’s reinforced heel and raw seam, together with suede heel, this Tall ugg boots is a pair of high-quality boots. But, we all know that UGG boots are of high price, so if we wanna buy boots of discount, we should wait for the time of UGG Classic tall sale when we could buy cheap <a href="www.allofshopping.com">UGGs boots</a>.</p>
<p>Ugg fans, if you would like to buy a pair of boots, both excellent in quality and cheap in price, why not come to UGG Classic tall sale?</p>
# Posted By ghjhgj | 9/25/09 7:25 AM
<p>Welcome to Buy UGG Classic tall boot.</p>
<p><a href="http://www.llikeonline.com">http://www.lli...;
UGG Classic tall boots are all made of genuine sheepskin imported from Australia, which can keep your feet utmost soft and let your feet breathe freely. Fashion will show UGGs tall modernity at a certain time, change as long as the trend is going. However, <a href="http://www.llikeonline.com">UGG Classic tall</a> sale are unchangeable classic for their high quality and classic elements. </p>
<p><a href="www.allofshopping.com">http://www.allofsho...;
UGG Tall Boots is genuinely made from Australian lavish twin-faced merino sheepskin. High quality, genuine sheepskin with premium fleece absorbs moisture like people’s derm to optimize the inner circumstance and keeps your feet dry and comfortable. The molded EVA outsole is extremely flexible and ethereal, and it will make a pair of perfect daily boots. There’s reinforced heel and raw seam, together with suede heel, this Tall ugg boots is a pair of high-quality boots. But, we all know that UGG boots are of high price, so if we wanna buy boots of discount, we should wait for the time of UGG Classic tall sale when we could buy cheap <a href="www.allofshopping.com">UGGs boots</a>.</p>
<p>Ugg fans, if you would like to buy a pair of boots, both excellent in quality and cheap in price, why not come to UGG Classic tall sale?</p>
# Posted By ghjhgj | 9/25/09 7:26 AM
Extravagance to an honest beauty [b][url=http://www.game4power.com]Buy wow gold[/url][/b]orc was having a [url=http://www.aionkina.com]aion gold[/url]permanent place to live with [url=http://www.cheapaion.com][b]Aion Kina[/b][/url]at all. They had been nomads or prisoners for [b][url=http://www.game4power.com/buy-gold/]buy cheap wow gold[/url][/b]so long that the concept of “home” had been all [url=http://www.game4power.com/]buy gold wow[/url]but lost. Several of the massive, greenish figures tilled a [url=http://www.gold4power.com]cheapest wow gold[/url]field. Watching the tusked, brutish-looking workers, Krasus marveled at [url=http://www.vipwarhammergold.com]warhammer gold[/url]the concept of orc farmers. Thrall, however[url=http://www.metin2sale.com]metin2 yang[/url] send off its power, was a [url=http://www.aionshopping.com]aion gold[/url]highly unusual orc and he had readilygrasped the ideas to[url=http://www.bestwarhammer.com]buy warhammer gold[/url]that would return [url=http://www.aionkinavip.com]aion kina[/url]stability to his people. Stability was something the entire world needed [url=http://www.gold4power.com]wow gold for sale[/url]badly. With another wave of his hand, the dragon mage dismissed [url=http://www.gold4power.com]wow gold cheap[/url]Kalimdor, summoning now a much closer location—the once [url=http://www.itemchannel.com]world of warcraft gold[/url]proud capital of his favored Dalaran. Ruled by the wizards of the Kirin Tor, the prime wielders of magic [url=http://www.aion4gold.com]aion gold[/url] for [url=http://www.cheapaion.com]cheap aion kina[/url], it had been at the forefront of the Alliance's battle against[url=http://www.game4power.com/]Wow Gold [/url]the BurningLegion[url=http://www.game4power.com/]www.game4power.com[/url] in Lordaeron and one of the first and most prized targets of the demons on[url=http://www.cheapaion.com][b]aion kina[/b][/url]in turn.
# Posted By aion kina | 9/30/09 7:33 AM
Our website have many goods,<A href="http://www.newstylerolex.com/"; title="Cheap Brand Name Watches">Rolex</A> -
<A href="http://www.newstylerolex.com/"; title="Replica Rolex">Replica Rolex</A> -
<A href="http://www.newstylerolex.com/"; title="Brand Name Watches">Replica Watches</A> -
<A href="http://www.newstylerolex.com/"; title="Brand Name Watches">Rolex Watches</A> -
<A href="http://www.sunglassvip.net"; title="Welcome to our Replica Watches website">Replica rolex</A> -
<A href="http://www.sunglassvip.net"; title="high quality timepieces">Rolex</A> -
<A href="http://www.2g-3g.com"; title="high quality timepieces">Rolex</A>
<A href="http://www.watches-life.com"; title="cheap price">Rolex</A>
<A href="http://www.watches-life.com"; title="cheap price">Replica Rolex</A>
<A href="http://www.rolex-hot.com"; title="cheaper price">Rolex</A>
<A href="http://www.rolex-hot.com"; title="cheaper price">Replica Rolex</A>
<A href="http://www.vertuexclusiveshop.com"; title="cheaper vertu">Vertu</A>
<A href="http://www.vertuexclusiveshop.com"; title="cheaper Replica vertu">Vertu Replica</A>,
<A href="http://www.e-lv.net"; title="Replica handbags">Replica handbags</A>,
<A href="http://www.enjoy-watches.com/"; title="high quality watches">Rolex</A>,
<A href="http://www.enjoy-watches.com/"; title="Brand Name Watches">Replica Watches</A>,
<A href="http://www.iphonebatteries.org/"; title="Batteries,Phone Batteries">Phone Batteries</A>,
<A href="http://www.lrolex.com/"; title="Batteries,Phone Batteries">Rolex</A>I belive that you will like them !050
# Posted By Replica Watches | 10/26/09 9:17 PM
Our website have many goods,<A href="http://www.newstylerolex.com/"; title="Cheap Brand Name Watches">Rolex</A> -
<A href="http://www.newstylerolex.com/"; title="Replica Rolex">Replica Rolex</A> -
<A href="http://www.newstylerolex.com/"; title="Brand Name Watches">Replica Watches</A> -
<A href="http://www.newstylerolex.com/"; title="Brand Name Watches">Rolex Watches</A> -
<A href="http://www.sunglassvip.net"; title="Welcome to our Replica Watches website">Replica rolex</A> -
<A href="http://www.sunglassvip.net"; title="high quality timepieces">Rolex</A> -
<A href="http://www.2g-3g.com"; title="high quality timepieces">Rolex</A>
<A href="http://www.watches-life.com"; title="cheap price">Rolex</A>
<A href="http://www.watches-life.com"; title="cheap price">Replica Rolex</A>
<A href="http://www.rolex-hot.com"; title="cheaper price">Rolex</A>
<A href="http://www.rolex-hot.com"; title="cheaper price">Replica Rolex</A>
<A href="http://www.vertuexclusiveshop.com"; title="cheaper vertu">Vertu</A>
<A href="http://www.vertuexclusiveshop.com"; title="cheaper Replica vertu">Vertu Replica</A>,
<A href="http://www.e-lv.net"; title="Replica handbags">Replica handbags</A>,
<A href="http://www.enjoy-watches.com/"; title="high quality watches">Rolex</A>,
<A href="http://www.enjoy-watches.com/"; title="Brand Name Watches">Replica Watches</A>,
<A href="http://www.iphonebatteries.org/"; title="Batteries,Phone Batteries">Phone Batteries</A>,
<A href="http://www.lrolex.com/"; title="Batteries,Phone Batteries">Rolex</A>I belive that you will like them !050
# Posted By Replica Watches | 10/30/09 11:28 PM
Girls are most afraid of cold feet, particularly in winter, if they are not protect their feet well from cold, it will be easier to affect the health of women. So, choose a pair of warm and comfortable australia boot is very important. It is well-know that UGG is a warm autumn and winter boots, the more emphasis on style, a pair of winter can guarantee that your feet comfortable and warm, 09 new autumn and winter UGG boots snow is easier than ever with style snow boots! Fashion Ugg boots can not just to keep feet warm and you will find that they are out to dinner, on the dance floor, at work or even when on holiday either when skiing or on the beach. In a word, they can be worn in almost any weather without your feet getting either cold or overheated, and their neutral colour tones allow them to be worn with a wide variety of clothing, even True Religion Jeans .No matter what look you are trying to achieve, the Ugg boot can help you to achieve it.UGG,the warmest present in this winter. Log in http://www.ugg24hours.com/
# Posted By ugg24hours | 11/2/09 1:21 AM
Girls are most afraid of cold feet, particularly in winter, if they are not protect their feet well from cold, it will be easier to affect the health of women. So, choose a pair of warm and comfortable australia boot is very important. It is well-know that UGG is a warm autumn and winter boots, the more emphasis on style, a pair of winter can guarantee that your feet comfortable and warm, 09 new autumn and winter UGG boots snow is easier than ever with style snow boots! Fashion Ugg boots can not just to keep feet warm and you will find that they are out to dinner, on the dance floor, at work or even when on holiday either when skiing or on the beach. In a word, they can be worn in almost any weather without your feet getting either cold or overheated, and their neutral colour tones allow them to be worn with a wide variety of clothing, even True Religion Jeans .No matter what look you are trying to achieve, the Ugg boot can help you to achieve it.UGG,the warmest present in this winter. Log in http://www.ugg24hours.com/
# Posted By ugg24hours | 11/2/09 7:39 PM
http://www.cheap-uggs-outlet.com/ uggs outlet
http://www.uggbootsstore.net/ uggs outlet
http://www.emu-boots.net/ emu boots
http://www.nike-star-shoes.net/ Nike basketball shoes
# Posted By uggs outlet | 12/8/09 3:37 AM
uggs sale http://www.uggbootsstore.net



Wholesale and retail are both acceptable to us. Welcome to our site and free to look! Thank you and wish you a nice day. Good Luck!
# Posted By uggs sale | 12/15/09 1:39 AM
http://www.uggbootstribal.com ugg boots
http://www.uggbootstribal.com cheap ugg boots
http://www.uggbootstribal.com ugg boots on sale
http://www.uggbootstribal.com UGG Australia
http://www.uggbootstribal.com uggs

http://www.uggbootstribal.com ugg boots for cheap
http://www.uggbootstribal.com ugg boots cheap
http://www.uggbootstribal.com uggs outlet
http://www.uggbootstribal.com fashion ugg boots
http://www.uggbootstribal.com wholesale ugg boots
http://www.uggbootstribal.com ugg sheepskin boots

http://www.ugg-mall.net ugg boots on sale


http://www.uggbootstribal.com/Infant-Erin-Ugg-Boots.html Infant Erin Ugg Boots

http://www.uggbootstribal.com/Nightfall-Ugg-Boots.html Nightfall Ugg Boots

http://www.uggbootstribal.com/UGG_Classic.html" target="_blank">http://www.uggbootstribal.com/UGG_Classic.html UGG Classic

http://www.uggbootstribal.com/Classic-Cardy-Ugg-Boots.html" target="_blank">http://www.uggbootstribal.com/Classic-Cardy-Ugg-Bo... Classic Cardy Ugg Boots

http://www.uggbootstribal.com/Short-Metallic-Ugg-Boots.html Short Metallic Ugg Boots

http://www.uggbootstribal.com/Tall-Metallic-Ugg-Boots.html Tall Metallic Ugg Boots

http://www.uggbootstribal.com/Ugg-Classic-Mini.html" target="_blank">http://www.uggbootstribal.com/Ugg-Classic-Mini.htm... Ugg Classic Mini

http://www.uggbootstribal.com/Ugg-Classic-Short.html" target="_blank">http://www.uggbootstribal.com/Ugg-Classic-Short.ht... Ugg Classic Short

http://www.uggbootstribal.com/Ugg-Classic-Tall.html Ugg Classic Tall

http://www.uggbootstribal.com/UGG_Classic_Argyle_Knit.html" target="_blank">http://www.uggbootstribal.com/UGG_Classic_Argyle_K... UGG Classic Argyle Knit

http://www.uggbootstribal.com/UGG_Classic_Crochet_Boots.html" target="_blank">http://www.uggbootstribal.com/UGG_Classic_Crochet_... UGG Classic Crochet Boots

http://www.uggbootstribal.com/UGG-Fluff-Flip-Flop.html UGG Fluff Flip Flop

http://www.uggbootstribal.com/UGG_Sandals.html UGG Sandals

http://www.uggbootstribal.com/Tasmina-Braid-Sandals-Ugg-Boots.html" target="_blank">http://www.uggbootstribal.com/Tasmina-Braid-Sandal... Tasmina Braid Sandals Ugg Boots

http://www.uggbootstribal.com/Ugg-Amelie-Suede.html Ugg Amelie Suede

http://www.uggbootstribal.com/UGG_Coquette_Sandals.html UGG Coquette Sandals

http://www.uggbootstribal.com/Ugg_Dakota_sandals.html Ugg Dakota sandals

http://www.uggbootstribal.com/UGG_Gypsy_sandals.html" target="_blank">http://www.uggbootstribal.com/UGG_Gypsy_sandals.ht... UGG Gypsy sandals

http://www.uggbootstribal.com/UGG_Halendi_sandals.html UGG Halendi sandals

http://www.uggbootstribal.com/UGG_Morocco_sandals.html" target="_blank">http://www.uggbootstribal.com/UGG_Morocco_sandals.... UGG Morocco sandals

http://www.uggbootstribal.com/Ugg-Slippers.html" target="_blank">http://www.uggbootstribal.com/Ugg-Slippers.html Ugg Slippers

http://www.uggbootstribal.com/Ugg_Stripe_Cable_Knit.html Ugg Stripe Cable Knit

http://www.uggbootstribal.com/UGG_Sundance_Grab_bags.html UGG Sundance Grab bags

http://www.uggbootstribal.com/Ugg-Sundance-II.html Ugg Sundance II

http://www.uggbootstribal.com/UGG_Ultra_boots.html UGG Ultra boots

http://www.uggbootstribal.com/Ugg-Ultra-Short-Boots.html" target="_blank">http://www.uggbootstribal.com/Ugg-Ultra-Short-Boot... UGG Ultra Short boots

http://www.uggbootstribal.com/Ugg-Ultra-tall-Boots.html" target="_blank">http://www.uggbootstribal.com/Ugg-Ultra-tall-Boots... Ugg Ultra tall Boots
# Posted By ugg boots | 12/30/09 3:10 AM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner