MSSQLSERVER_1461
Applies to: SQL Server
Details
Attribute | Value |
---|---|
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for