1457
Product Name Event ID 1457 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_PAGE_UNDO_
Product
Name
Event ID
1457
Event
Source
MSSQLSERVER
Component
SQLEngine
Symbolic
Name
DBM_PAGE_UNDO_PENDING
Message
Text
Synchronization of the mirror database, ’%.*ls’, was interrupted, leaving the database in an
inconsistent state. The ALTER DATABASE command failed. Ensure that the mirror database
is back up and online, and then reconnect the mirror server instance and allow the mirror
database to finish synchronizing.
This messages indicates that the ALTER DATABASE
database_name
SET PARTNER OFF statement
has failed. The failed attempt to remove database mirroring interrupted synchronization of the
mirror database. The database is in an inconsistent state.
To resolve this error, you can take either of the following actions:
Restore contact between the mirror server and the principal server to allow for the mirror
database to synchronize.
Drop the mirror database.
ノ
Expand table