• 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.