Bulk_Logged recovery...

I have some confusion to start using bulk_logged recovery model. currently our db run with FULL recovery, but everyday around 9am - 11am ( 2 hours ), our bulk insert and select into is running. so I'm thinking to change the recovery during this 2 hour time to Bulk_logged.

So when I change the recovery mode to Bulk_Logged at 9am-11am, and if there is some insert or delete or update occurring during this hour, will I lost this data if point in time recovery is needed ?
motioneyeAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
in short: only the bulk-logged statements are lost, not the others.

so, in short, you should not only plan to change the recovery model back to full, but also run a full backup (or differential backup) after that immediately.
0
 
motioneyeAuthor Commented:
From the Mcsft Link http://msdn.microsoft.com/en-us/library/ms190203.aspx, they claim log backups is enough, Pls confirm
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
yes, except that it will NOT be able to handle the transactions that are actually bulk operations. the data modifications done by that type of statements will only log that they occured, but not which data actually has been modified.
0
 
motioneyeAuthor Commented:
Thanks angelIII, I understoods
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.