fatinfzi (3/25/2013)
Hi,I need help with my database. The database is mirror to another database and not the disk is full. No free space for transaction log. One of my colleague suggest me to remove the mirroring and change the recovery mode to simple. But i need the database to be mirrored to another database. Please help me on this.
Hi, I went through similar situation recently, my log drive was getting full and when I checked the log backups, it was failing due to space also......so, to fix this issue, I took a manual log backup and shrank the log file to free up space. Sometimes you have to do more than 1 log backups in order to shrink.
So, I am not sure if you have same scenario, but it seems like log backup issue.
Also, check the mirroring monitor and see how much unsent log, etc.
Regards,
SueTons.
Regards,
SQLisAwe5oMe.