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
@ShubhenduKumarKundu3 ай бұрын
After successful synchronized, secondary database shown restoring mode. How do I get back in normal mode with synchroinized?
@chandustechnet42143 ай бұрын
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-p7v9 күн бұрын
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-kc6ni6uq6d6 ай бұрын
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?
@chandustechnet42146 ай бұрын
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.
@JSunilKumar05086 ай бұрын
How to troubleshoot 927 error in Database Mirroring ?
@chandustechnet42146 ай бұрын
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.
@JSunilKumar05086 ай бұрын
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.
@chandustechnet42146 ай бұрын
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.
@prashantbhosale56359 ай бұрын
Please show how to configure on domain server
@chandustechnet42149 ай бұрын
You mean to configure database mirroring on cluster environment?