MSSQLSERVER_1406

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
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.

Explanation

The SQL Server Database Engine cannot force service because the mirroring state cannot guarantee that the force service process would work correctly.

User Action

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

See Also

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