Database is in Not Synchronizing/Suspect on the secondary server

This video helps to troubleshoot and fix the Alwayson database on secondary is marked as not synchronizing/suspect

[@kuswas_rr]

I learnt something new because of you... thank you..

[@muneerdba]

Very usefull troubleshooting session.. Esp the datafile backup and restore to existing AG DB.

[@tonyettah]

God bless you for sharing your knowledge with us.*****

[@sonnetbarua8126]

Best best best ever!!!!many many thanks

[@mohammedmustofa8960]

nice, very helpful

[@beinghuman77733]

Nice Explanation Sir

[@indrakasu8820]

Excellent

[@chandrasekhar-xu3nz]

Super.!

[@azuredevops1650]

Thanks

[@narareddy770]

🎉🎉

[@chandrakalavathigajjala7525]

so nice sir
sir i need answer for how to solve freequently deadlock issues in ms sql server? plz answer if possible

[@annuali7456]

👌👌👌👌👌👌👌👌👌👌👌👌👌👌

[@mufayt]

I have an issue our nav not connecting data base after it's suspected

[@chandustechnet4214]

If the primary database status is suspect, application would not be able to connect.
Action you may have to perform are:
1. remove database from alwayson
2. After removed the database from primary, check if synchronous secondary can bring it online, so that application connection redirect to connect to the secondary replica
3. If step 2 doesn't work. Restore from backup or repair the database

[@ImranKhan-er4od]

Can database be removed from AG on primary ?

[@chandustechnet4214]

Yes, you can remove the database from the secondary and/or primary as well.

[@sandykalyan7124]

Hi brother can you do vedio on what are all the queries we use daily as a MSSQL DBA❤

[@chandustechnet4214]

Sure, thank you.

[@poonamtiwari5573]

Please continue Class suru kare sir live Class for ms sql administrator ka

[@chandustechnet4214]

Sure, thanks for the feedback. If we have more people interested, I can take DBA classes. Currently I'm taking performance tuning classes. Let me know if anyone is interested for enxt batch.

[@charanteja501]

Hi sir im interested to join the classes could you please provide your contact details

[@chandustechnet4214]

[e-mail]

[@rodrifc]

Thanks