September 25, 2016 at 12:58 pm
Yanum_Vlad (9/25/2016)
Dear all,I still do not catch, how Full (!) log backup works when Bulk Minimal logging is in place.
BOL states:
Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log backup contains both log records and the data pages that were changed by bulk operations.
There's no such thing as a "Full log backup", log backups are log backups, the BoL entry is correct about how log backups work in bulk-logged recovery when there are minimally logged operations
But what about Full recovery model?
There are no minimally-logged operations in full recovery model, log backups only contain log records as all operations are fully logged
https://msdn.microsoft.com/en-us/library/ms190203.aspx
What does mean #4 there?
Not sure what part of that page you're referring to.
As for me, I would really make full / deferential backup to ensure no data loss.
There is no need to take a full/diff backup after switching from Bulk-logged to Full recovery. A log backup is a good idea, and if you're worried about the inability to recovery, a log backup is all you need.
p.s. 7 year old thread (with a lot of incorrect statements in it), if you have a question, a new thread is preferred.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply