MSSQLSERVER_1461

Details

Product Name

SQL Server

Product Version

10.0

Product Build Number

-

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.