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 Monday, January 14, 2013 3:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 28, 2014 10:39 AM
Points: 36, Visits: 257
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.
Post #1406972
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse