when I do resume the mirror it trys to synchronize but fails and suspends itself after around 30 seconds always with the same size of unrestored log - does this mean there is a bad part of the log?
And you dont want to break the mirror because if it happen then you need full backup of the live database and restore it to the mirror.
Sometimes suddenly we see that Mirror is suspended. This is a common problem, and this error normally comes up from the when either the Data Disk or Log Disk is getting full. So Clean the Disk and Let the Mirror Continue Easily. Remember to resume the Mirror by going Task->Mirror-> Resume.
And always start trouble shooting by looking at the logs of the SQL rather than looking at google first :)
And you dont want to break the mirror because if it happen then you need full backup of the live database and restore it to the mirror.
Sometimes suddenly we see that Mirror is suspended. This is a common problem, and this error normally comes up from the when either the Data Disk or Log Disk is getting full. So Clean the Disk and Let the Mirror Continue Easily. Remember to resume the Mirror by going Task->Mirror-> Resume.
And always start trouble shooting by looking at the logs of the SQL rather than looking at google first :)
No comments:
Post a Comment