Troubleshooting Database Mirroring Error 1418

[@goguladhananjineyulu3174]

THANK YOU SO MUCH ANNA 😍🥰

[@kishoreevani5813]

well explained each small thing in the video. Awesome sir.

[@giribabu7009]

Nice video thank you for giving end to end clarification

[@user-ns9lp8cm9z]

Thanks very good explanation

[@Gabriel-kx4qv]

Nice vídeo, ty

[@giribabu7009]

Suggested to upload more videos and share knowledge replications, migration, performance issues etc.,

[@chandustechnet4214]

Sure, thanks for the feedback

[@ShubhenduKumarKundu]

After successful synchronized, secondary database shown restoring mode. How do I get back in normal mode with synchroinized?

[@chandustechnet4214]

Need to look into the logs to understand the issue. But just a couple of generic checks, make sure both principal and mirror are on the same build/version. Please check the algorithm you're using and make sure it's AES but not RC4 algorithm.

[@helloRChere]

Hi Chandu, Do you provide DBA Training

[@FardinNoman-p7v]

When I will implement database mirroring in 2 different server then what are the things I have to mention in service accounts? There are 2 options one is principle & another one is mirroring. Whether i have to put server name or anything else just clear this part. Thanks.

[@chandustechnet4214]

Service accounts should be domain accounts.

[@user-kc6ni6uq6d]

Hi Guys It Worked. But i cannot Open the Mirrored Database after the mirroring process. it Says The database TestMirror is not accessible. (ObjectExplorer) any Solutions?

[@chandustechnet4214]

What do you mean "you cannot open the mirrored database", you cannot access the mirrored database because it's always in restoring state. You can access only the principal.

[@JSunilKumar0508]

How to troubleshoot 927 error in Database Mirroring ?

[@chandustechnet4214]

What's the SQL version? Please check if you've any pending logs to be restored. It's not an error or issue, if the LSN should be in sync with the primary. Make sure that no log backup jobs running on primary while configuring mirroring. Restore necessary logs and then configure.

[@JSunilKumar0508]

Principle Server: SQL 2017 Developer Edition Mirror Server: SQL 2019 Developer Edition. Took one Full & one Transaction log backups from Principle Server, same Restored in Mirror server. Then configured. Observed 927 error.

[@chandustechnet4214]

Please share the error message and check if any logs pending to restore. To isolate the issue, you can create a test database and try to configure. **Make sure that database mirroring endpoint encryption algorithm configured with AES but not RC4.

[@prashantbhosale5635]

Please show how to configure on domain server

[@chandustechnet4214]

You mean to configure database mirroring on cluster environment?