Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

An examination of bulk-logged recovery model Expand / Collapse
Author
Message
Posted Saturday, May 5, 2012 8:36 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 42,812, Visits: 35,931
Comments posted to this topic are about the item An examination of bulk-logged recovery model


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1295629
Posted Monday, May 7, 2012 3:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 7, 2014 10:47 AM
Points: 1,248, Visits: 1,196
Thanks Gail.

Well worth the read!
Post #1295843
Posted Monday, May 7, 2012 6:43 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:55 AM
Points: 558, Visits: 1,475
Thank you Gail, your article has really helped further my understanding of this rather murky area. It's great that you and other experts take the time out to help the community, it really is appreciated.
Post #1295897
Posted Monday, May 7, 2012 7:52 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:34 AM
Points: 1,566, Visits: 1,851
Awesome!
Thank you, Gail, for taking the time to write such a thorough, detailed article.
Post #1295915
Posted Monday, May 7, 2012 2:02 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:54 PM
Points: 369, Visits: 299
Superb Article...


Kind Regards,

Chintak Chhapia

Post #1296091
Posted Monday, May 7, 2012 4:36 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:49 PM
Points: 1,317, Visits: 514
Thank you Gail for the excellent article.

I do have one question: in the final demo where you looked at the log usage for an index rebuild, you mentioned "log reservation in case of rollback". Could you clarify what you mean by this?
Post #1296158
Posted Monday, May 7, 2012 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 7, 2012 7:17 PM
Points: 5, Visits: 2
==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.scnshop.com ) =====

==== ( http://www.scnshop.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

Post #1296179
Posted Monday, May 7, 2012 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 7, 2012 7:17 PM
Points: 5, Visits: 2
==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.scnshop.com ) =====

==== ( http://www.scnshop.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

Post #1296180
Posted Monday, May 7, 2012 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 7, 2012 7:17 PM
Points: 5, Visits: 2
==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.scnshop.com ) =====

==== ( http://www.scnshop.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

Post #1296181
Posted Monday, May 7, 2012 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 7, 2012 7:17 PM
Points: 5, Visits: 2
==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====


$33 True Religion jeans, Ed Hardy jeans,LV,Coogi jeans,Affliction jeans

$30 Air Jordan shoes,Shox shoes,Gucci,LV shoes

50%Discount winter fashion :Sandle,t-shirt,caps,jerseys,handbag and brand watches!!!

$15 Ed Hardy ,LV ,Gucci Bikini

$15 Polo, Ed Hardy, Gucci, LV, Lacoste T-shirts

$25 Coach,Gucci,LV,Prada,Juicy,Chanel handbag,

$10 Gucci,Ed Hardy sunglasses

$9 New Era caps.

give you the unexpected harvest

==== ( http://www.scnshop.com ) =====

==== ( http://www.scnshop.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====



==== ( http://www.fullmalls.com ) =====

==== ( http://www.fullmalls.com ) =====

Post #1296182
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse