Online backup performance

New Member

Re: Online backup performance

If table a is having thousands of records and online backup is in progress but a user is simultaneously deleting all of those records, how will the backup happen?


Re: Online backup performance

@Fred provided the answer already:

This journal is appended to the backup of the table, and used to automatically "roll back" to the initial consistency point (start of the backup) during a restore.

I.e. the restored table still has all those deleted rows.