MSSQLSERVER_1461

  • Article

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

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.

Explanation

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.

User Action

To set transaction safety off, rerun the ALTER DATABASE database_name SET PARTNER SAFETY OFF statement on the principal database.