| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_1406 |
MSSQLSERVER_1406 |
MashaMSFT |
mathoma |
04/04/2017 |
sql |
supportability |
reference |
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
| 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. |
The [!INCLUDEssDEnoversion] 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)