1

Log shipping is one of methods for high availability/disaster recovery. It works by transferring the transaction logs from primary to the secondary.

Log shipping needs that the database should be either in full recovery mode or bulk logged recovery mode.

My questions is: Since the Bulk logged recovery mode doesn't log the bulk operations, then why is it allowed in log shipping? Doesn't this mean it violates the principle of high availability/disaster recovery because the secondary database will be missing all the data that was added into primary via bulk operations (as these are not written to the transaction log)?

Improve this question

1 Answer 1

Reset to default
2

"Bulk logged recovery mode doesn't log the bulk operations" - it's a wrong message. Instead of writing information about adding each row to the log file it writes full pages which were affected by a bulk logged operation to the log backup.

You could read more: Bulk Changed Map (BCM): The Minimally Logged Advantage

Improve this answer
2
  • In particular the reason this works is stated in the linked article: "During a log backup, [affected by a minimally logged operation] are added to the backup in addition to the normal log information." So while it's true that the data isn't written to the log file, it is written to the log backups. Commented Oct 9, 2018 at 13:25
  • Hello, then why is it that this recovery model doesnt support point in time recovery? Commented Oct 11, 2018 at 12:56

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.