Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 3 down vote accepted

Yes the database is available for use during the backup.

The way the backup process works is basically this.

When the backup database command is taken, the server triggers a checkpoint. Then the database backup is started, and no more checkpoints are issued. When the data is backed up from the database files the transaction log is then backed up. When the backup of the log is complete another checkpoint is issued.

The backup is consistent at all times, and is current as of the end of the backup job.

share|improve this answer
thanks!!!!!!!!! – Andrei Rinea Apr 25 '11 at 17:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.