September 15, 2010 at 2:02 pm
I have a couple of databases which are log shipped. So as a result of that database transaction logs are backed up and shipped.
I have noticed that when maintenance plan to rebuild/ reorganize indexes kicks in.. transactions logs become enormous.. in some cases I get about 50 GB growth in about half hour. I wonder why that is and what can be done to not log that activity without messing up the log shipping.
September 15, 2010 at 2:14 pm
Swap to bulk-logged. The target system(s) will have to recreate the work but your logs will be smaller.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 15, 2010 at 2:42 pm
how does that impact log shipping?
September 15, 2010 at 2:46 pm
It won't directly impact it, but it will let your logs get transferred faster because their smaller. You can find out more details about the specifics between full and bulk-logged in BoL and other sources, but the short form is that both of those (ignoring simple) are full logging, just it takes longer to recover (or process) a bulk-logged then a full log, because things like index rebuild are simply dropped into the log in the form of (SQL Psuedocode) "Rebuild Index idx_BadIndex" instead of "Move page BadIndex 10342342:329083 to 1032214231:3231328, split page 12312321:1232897...."
It will still allow log shipping, just expect it to take longer after the transfer on the target systems... because it'll be doing the reindexing itself, instead of just applying the work already computed and listed in the larger log files.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply