MSSQLSERVER_1406

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

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

Tasks

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

Concepts

Removing Database Mirroring (SQL Server)