December 12, 2018 at 2:30 am
Hello everyone
I have two mirroring instances in high synchronous security mode
if I make an attempt to fail through an alter database set partner failover
the base switches from synchro to suspended modeI tried alter database set partner resume but without result
Who has an idea about the root cause of error
December 12, 2018 at 3:03 am
abdalah.mehdoini - Wednesday, December 12, 2018 2:30 AMHello everyone
I have two mirroring instances in high synchronous security mode
if I make an attempt to fail through an alter database set partner failover
the base switches from synchro to suspended modeI tried alter database set partner resume but without result
Who has an idea about the root cause of error
Check the endpoints and account are working.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 12, 2018 at 9:52 am
i have this MSG in error log
Error: 948, Severity: 20, State: 2.The database 'ABM' cannot be opened because it is version 663. This server supports version 661 and earlier. A downgrade path is not supported.
Error: 1454, Severity: 16, State: 1.
Database mirroring will be suspended. Server instance 'LQUAAWbDSQL11\BLU01111' encountered error 948, state 2, severity 20 when it was acting as a mirroring partner for database 'ABM'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
December 12, 2018 at 10:33 am
The primary and secondary nodes are not at the same patch levels.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply