Database is in Not Synchronizing/Suspect on the secondary server

[@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.

[@telugutechgamerz1819]

Hi , I have question as per the video you have mentioned that taking backup of seconday datafile why can't we take the backup of transactional log when datafile has been and restore it in to the secondary server with move option instead taking the ndf file level backup?In this case log file has secondary datafile information and we can restore it in to the seconday database with move option?It would be great if any clarification?

[@reddynaresh-bl1rh]

Thanks brother it is helpful 🙏👍

[@tonyettah]

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

[@chandrakalavathigajjala7525]

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

[@sonnetbarua8126]

Best best best ever!!!!many many thanks

[@sqltechzpestechz7053]

Thank you very much… just one thing to clear if we use the ‘Join only’ option then we have to restore a log backup also with ‘no recovery’ option correct??

[@chandustechnet4214]

Correct. You will have to restore required log backups with norecovery. Make sure, log backup jobs are disabled until the secondary is in sync.

[@beinghuman77733]

Nice Explanation Sir

[@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.

[@mohammedmustofa8960]

nice, very helpful

[@satish_sql5321]

at 8:00 we can see db1 and db1_log

[@chandustechnet4214]

Thanks for checking. I've created a folder called DB1 and inside we've database files on Node1 and it doesn't exist on node 2. That's the issue.

[@indrakasu8820]

Excellent

[@narareddy770]

🎉🎉

[@annuali7456]

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

[@azuredevops1650]

Thanks

[@sandykalyan7124]

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

[@chandustechnet4214]

Sure, thank you.

[@chandrasekhar-xu3nz]

Super.!

[@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.

[@manishkambleofficial]

Try Hindi Series Also Please

[@charanteja501]

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

[@chandustechnet4214]

[e-mail]

[@rodrifc]

Thanks