Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 have a pair of SQL Server 2008 R2 servers hosting a synchronously mirrored database with no witness. This weekend, we had to do some network maintenance so I paused the mirroring. Upon resuming, the principal's status reverted to the usual Principal, Synchronized. The mirror, however, now reads Mirror, Synchronized / Restoring... I don't recall the Restoring... part usually being there.

The transaction log has begun to grow on the principal, as well, despite hourly log backups. This suggests to me that the synchronization process isn't freeing up transaction log space.

What's going on here and how do I fix it?

share|improve this question
It is likely that the Restoring... was always there. Have you done a Full backup since restarting – jgardner04 May 21 '12 at 14:58
I haven't done a full backup since restarting, but my incrementals are running normally and the log is still growing. – sh-beta May 21 '12 at 15:50

Mirror, Synchronized / Restoring... is the typical state for the mirror instance.

You can determine why the log file is growing by issuing the following command in a SQL Server Management Studio query window:

FROM sys.databases 
WHERE name='your_database_here';

This will show several possible choices, such as:


You may need to perform at least one transaction log backup, among other actions depending on the LOG_REUSE_WAIT_DESCRIPTION shown in the query above. For instance, there may be a long-running transaction that is forcing the log files to not be re-used.

share|improve this answer
As I recall only transactional backups will clear the database log file, not the full backup. Isn't it ? – Sina Hassanpour Dec 8 '15 at 21:56
yes, @SinaHassanpour - that is exactly correct. I have corrected my answer. – Max Vernon Dec 8 '15 at 22:09

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.