March 8, 2010 at 12:00 pm
Hi everyone,
I have two SQL 2005 SP3 servers that are part of high performance mirroring without the use of a witness server. My principal database logs have grown to 104GB over the weekend and yet the mirroring is not sending anything to the mirror. The principal's status is "Principal, Synchronizing" and the mirror's status is "Mirror, Synchronizing / Restoring...". I am not sure how to proceed with this problem, any help would be greatly appreciated!
March 8, 2010 at 9:54 pm
Check the disk space on both the servers.
Check if the mirroring is sync with the Mirror DB by monitoring.
http://msdn.microsoft.com/en-us/library/ms365786.aspx
Post the error you are facing. Check the event log for any information..
-Win.
Cheers,
- Win.
" Have a great day "
March 8, 2010 at 10:00 pm
Okay, you have mirroring setup, but are you running periodic transaction log backups on the principle server?
If not, that will explain why your log file on the principal server has grown so large.
We just setup mirroring on two production databases, and the transfer rate most of the time is 1 to 3 KB, but when I check the logs, i have seen as highs near 200KB/sec.
March 10, 2010 at 8:45 am
Did you look at the diskk space on your mirror box? What was it?
Also you can look at the size of the log file on the mirror (it should be the same size as the principal).
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply