Skip to content

Latest commit

 

History

History
38 lines (32 loc) · 1.38 KB

File metadata and controls

38 lines (32 loc) · 1.38 KB
title MSSQLSERVER_1406 | Microsoft Docs
ms.custom
ms.date 04/04/2017
ms.prod sql
ms.reviewer
ms.technology supportability
ms.topic language-reference
helpviewer_keywords
1406 (Database Engine error)
ms.assetid 915f97de-9b74-41f8-8bd5-b2d061416718
author MashaMSFT
ms.author mathoma

MSSQLSERVER_1406

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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 [!INCLUDEssDEnoversion] 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)