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.
See Also