An examination of bulk-logged recovery model

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gail Shaw » An examination of bulk-logged recovery model

31 posts, Page 4 of 4

«««1 2 3 4

An examination of bulk-logged recovery model

Rate Topic

Display Mode

Topic Options

Author

Message

kudz

Posted Monday, January 14, 2013 3:55 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:15 AM
Points: 28, Visits: 202

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 »

31 posts, Page 4 of 4

«««1 2 3 4

Permissions