MSSQLSERVER_1406

Applies to: SQL Server Azure SQL Managed Instance

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)