I am expecting to have a long backup on a certain database and I was wondering if the application can access (read only? read/write?) it while it is being backed up.
If read/write access would be available then how will consistency be achieved? Probably only a snapshot of what was available at the time of the start of the backup will be included in the backup?
Or will the database be non-operational during backup?