MSSQLSERVER_1406

New: 17 July 2006

Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399

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

Other Resources

Forced Service (with Possible Data Loss)
Removing Database Mirroring

Help and Information

Getting SQL Server 2005 Assistance