monitor
#monitor#1406

1406

Product Name Event ID 1406 Event Source MSSQLSERVER Component SQLEngine Symbolic Name DBM_BADSTATEFORF

Product Name

Event ID

1406

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

DBM_BADSTATEFORFORCESERVICE

Message Text

Unable to force service safely. Remove database mirroring and recover database ”%.*ls”

to gain access.

The SQL Server Database Engine cannot force service because the mirroring state cannot

guarantee that the force service process would work correctly.

Remove database mirroring. You can then recover the mirror database to gain access to it.

Force Service in a Database Mirroring Session (Transact-SQL)

Removing Database Mirroring (SQL Server)

Expand table