<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Mohammed Moinudheen...
»
Bulk Logged recovery model
36 posts, Page 1 of 4
1
2
3
4
»
»»
Bulk Logged recovery model
Rate Topic
Display Mode
Topic Options
Author
Message
mohammed moinudheen
mohammed moinudheen
Posted Saturday, April 14, 2012 4:48 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 7:43 PM
Points: 2,174,
Visits: 3,586
Comments posted to this topic are about the item
Bulk Logged recovery model
Mohammed Moinudheen
Post #1283686
mohamed_ajeez
mohamed_ajeez
Posted Sunday, April 15, 2012 10:30 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, July 31, 2012 3:02 AM
Points: 61,
Visits: 34
Excerpt from the link:"Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log backup contains both log records and the data pages that were changed by bulk operations. This is necessary to capture the results of the bulk-logged operations. The incorporated data extents can make a log backup very large."
yes it is correct then in many artical explained in bulk-logged recovery log file not getting high size, which is true?, i checked out , in bulklog recovery log file getting high size during the operation, then what is use of bulklog recovery..
Post #1283751
The CosmicTrickster
The CosmicTrickster
Posted Sunday, April 15, 2012 3:21 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 5:34 PM
Points: 2,605,
Visits: 760
"Now, after you take a log backup, could you see a log file bigger than usual?"
No points for me. I perceive there being a difference between a "backup file" and a "log file". If someone says "log file" to me, I take it to mean the transaction log file, not the backup.
Scott Duncan
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Post #1283824
Nakul Vachhrajani
Nakul Vachhrajani
Posted Sunday, April 15, 2012 11:38 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:02 AM
Points: 1,277,
Visits: 1,609
The way I interpreted the question was:
1. Database is in full-recovery mode
2. User foresees bulk-operations (i.e. to be performed sometime in the future)
3. User therefore changes the database to bulk-logged recovery mode
4. User takes a log backup after changing the recovery model
I was unable to find a step that indicates whether bulk-logged operations were actually peformed. As log as bulk-logged operations are not performed, the log file size would not be impacted if the backup was taken immediately after changing the recovery model.
In my humble opinion, the question leaves room for an interpretation that's different than what the actual intention is.
Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.
Follow me on
Twitter:
@nakulv_sql
Google Plus:
+Nakul
Post #1283879
call.copse
call.copse
Posted Monday, April 16, 2012 3:16 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 1,088,
Visits: 693
I would go further than the other posters on this thread - sorry, this question and the answer given are just plain WRONG.
See this MSDN blog entry which clearly explains log sizes in different modes:
http://blogs.msdn.com/b/suhde/archive/2010/12/29/transaction-log-backup-size-in-bulk-logged-recovery-model.aspx
The LOG FILE BACKUP is certainly likely to be larger.
The LOG FILE (subsequent to backup) is almost certainly SMALLER given that it is not doing point in time restore.
I will accept that the question could have been mangled unintentionally in the editorial prcess or something - but, the fact remains, the correct answer to the question as written is NO.
Post #1283948
Carlo Romagnano
Carlo Romagnano
Posted Monday, April 16, 2012 3:57 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 12:56 AM
Points: 1,972,
Visits: 1,822
Nakul Vachhrajani (4/15/2012)
The way I interpreted the question was:
1. Database is in full-recovery mode
2. User foresees bulk-operations (i.e. to be performed sometime in the future)
3. User therefore changes the database to bulk-logged recovery mode
4. User takes a log backup after changing the recovery model
I was unable to find a step that indicates whether bulk-logged operations were actually peformed. As log as bulk-logged operations are not performed, the log file size would not be impacted if the backup was taken immediately after changing the recovery model.
In my humble opinion, the question leaves room for an interpretation that's different than what the actual intention is.
+1
I'm waiting for Hugo opinion.
Post #1283971
Rich Weissler
Rich Weissler
Posted Monday, April 16, 2012 5:14 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 5:08 AM
Points: 1,566,
Visits: 770
call.copse (4/16/2012)
The LOG FILE (subsequent to backup) is almost certainly SMALLER given that it is not doing point in time restore.
Hmm. Perhaps I'm missing something.
Even if we are talking about the Log File... not the log backup... unless there was a subsequent Shrink Operation, it certainly will NOT be smaller. There is a fair chance it'll be the same size... and the question asks COULD it be bigger?
It could be the same size, or bigger... but nothing says it HAS to be the same size (unless someone turned off autogrowth.)
For me, I interpreted the question to be able to backup files of the transaction log... so I didn't even start thinking in these terms until I'd seen what you folks had written.
Post #1284004
L' Eomot Inversé
L' Eomot Inversé
Posted Monday, April 16, 2012 5:16 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110,
Visits: 7,184
What an horribly wrong question and answer!
I agree with call.copse and with The CosmicTrickster: the question is plainly about the log file not the backup, but the answer is plainly about the backup, not the log file.
Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1284010
L' Eomot Inversé
L' Eomot Inversé
Posted Monday, April 16, 2012 5:25 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110,
Visits: 7,184
Rich Weissler (4/16/2012)
call.copse (4/16/2012)
The LOG FILE (subsequent to backup) is almost certainly SMALLER given that it is not doing point in time restore.
Hmm. Perhaps I'm missing something.
Even if we are talking about the Log File... not the log backup... unless there was a subsequent Shrink Operation, it certainly will NOT be smaller. There is a fair chance it'll be the same size... and the question asks COULD it be bigger?
It could be the same size, or bigger... but nothing says it HAS to be the same size (unless someone turned off autogrowth.)
For me, I interpreted the question to be able to backup files of the transaction log... so I didn't even start thinking in these terms until I'd seen what you folks had written.
Interesting interpretation: "can the size of the log file at some time be smaller that its size at some earlier time" your interpretation would make sense, but with the wording of the question I would say that that interpretation probably requires treating it as a trick question. I suppose though that we should maybe remember that trick questions do turn up now and again and that some people use over-literal English which gives the impression of a trick question when no trick was intended.
Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1284020
Thomas Abraham
Thomas Abraham
Posted Monday, April 16, 2012 5:39 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:58 AM
Points: 1,152,
Visits: 1,457
Thank you for the question. I thought the question was straightforward, but then it's Monday.
Please don't go. The drones need you. They look up to you.
Post #1284026
« Prev Topic
|
Next Topic »
36 posts, Page 1 of 4
1
2
3
4
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
