monitor
#monitor#32043

32043

Product Name Event ID 32043 Event Source MSSQLSERVER Component SQLEngine Symbolic Name SQLErrorNum32043 Message Text The alert f

Product Name

Event ID

32043

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SQLErrorNum32043

Message Text

The alert for ‘unrestored log’ has been raised. The current value of ‘%d’ surpasses the

threshold ‘%d’.

This database mirroring event is issued on the mirror server instance to indicate that the

amount of unrestored log reached a user-specified threshold value. Typically, this event occurs

because the performance of the system has changed. Either the bandwidth between the two

systems has decreased, or the load has increased.

An unrestored log is a log that has been received by the mirror server instance and written to

disk but is waiting to be restored to the mirror database. The amount of unrestored log in

kilobytes (KB) is a performance metric that can help you evaluate the current failover time. The

time that is required to apply the unrestored log is the main factor in failover time, along with a

short additional time that is required to recover the database and bring it online.

Expand table

Note

For an automatic failover, the time for the system to notice the failure is independent of

the failover time.