| title | MSSQLSERVER_1461 | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 04/04/2017 | |
| ms.prod | sql | |
| ms.reviewer | ||
| ms.technology | supportability | |
| ms.topic | language-reference | |
| helpviewer_keywords |
|
|
| ms.assetid | fce10907-4753-441b-b624-f28e00ed7520 | |
| author | MashaMSFT | |
| ms.author | mathoma |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
| Product Name | SQL Server |
| Event ID | 1461 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | DBM_SAFETY_MISMATCH |
| Message Text | Different database mirroring safety levels among servers were detected for database "%.*ls". The FULL safety level will be used. |
Mirroring connections were broken when the transaction safety level was modified because the transaction safety settings were inconsistent on the principal and mirror databases. The default safety setting of full-transaction safety will be used. The session will run in high-safety mode.
To set transaction safety off, rerun the ALTER DATABASE database_name SET PARTNER SAFETY OFF statement on the principal database.