Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


An examination of bulk-logged recovery model


An examination of bulk-logged recovery model

Author
Message
kudz
kudz
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 458
I re-created the statement(with a new database) and everything went OK!
But I really can't understand why I'm n0t getting minimal logging in the code posted on the following url:

This is the steps I'am doing

1º Create database
2 º Set Recovery Model to Bulk Logged
3º Verify on sys.databases the recovery model
4º Backup database (.bak)
5º SELECT INTO + SHUTDOWN WITH NOWAIT
6º DELETE MDF
7ºRESTART SQL
8º BACKUP TAIL LOG WITH NO_TRUNCATE
9ºRESTORE DATABASE WITH NORecovery
10º RESTORE LOG WITH RECOVERY(Error)
11 º RESTORE LGO WITH RECOVERY,CONTINUE_AFTER_ERROR(OK)
12 º SELECT * From SomeTable( AAAAAAAA)

Code Used: http://pastebin.com/NZqkcKSY


Thanks for your help


GilaMonster (1/14/2013)
Just go over it a couple times, make sure you are getting minimal logging. I ran that particular test a number of times, as did a friend and, while we got a variety of different errors, we did not get the table back intact after any of the tests.

nikimodi-787823
nikimodi-787823
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 51
Great! So informative with detailed scenarios.
Worth a read.

One more disadvantage of Bulk logged recovery model is that if there are Bulk inserts, transaction log backup contains modified extents instead of individual log records (in case of Full recovery model). Hence the size of log backup increases tremendously.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search