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 have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State. Clients can access those databases. So what happens when they keep on adding data to these databases?? Will the data get committed or waits till the mirror comes up?

share|improve this question

1 Answer 1

Data will be committed, otherwise the mirroring would be known as the 'high unavailability' feature. The log(s) on the principal will grow as it must hold all transactions that are no shipped over to the mirror. When eventually the mirror comes back up the principal will show PRINCIPAL/SYNCHRONIZING as the log will be shipped over to the mirror. The log(s) will start to free up as transactions are being shipped to the mirror. When the all the transactions were received by the mirror the principal will enter the state PRINCIPAL/SYNCHRONIZED. Depending on the mirroring type (synchronous/asynchronous) in this state the clients may wait for all every transaction to be shipped to the mirror when committing.

If the disconnect is long and the log(s) had grown very large on the principal, the mirror will have to grow the log to a similar size when it re-connects. If there isn't sufficient disk space, mirroring will not resume (the ERRORLOG and system event log on the mirror will indicate this problem).

share|improve this answer
    
ok thanks. But why the log on the pricipal grows though it commited data ? The logs wil be active/inactive on the principal database when the mirror is disconnected? –  user23996 Apr 5 '10 at 13:12
    
The log file grows because it has to store everything not delivered to the mirror. –  Remus Rusanu Apr 5 '10 at 15:48
    
ok that means we cannot truncate the logs till they are sent to the mirror . Is that right? –  user23996 Apr 7 '10 at 4:46
    
Right. Log will be 'in use' until sent. –  Remus Rusanu Apr 7 '10 at 17:54
    
ok thank you... –  user23996 Apr 12 '10 at 7:08

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.