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.