Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.