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?
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??
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
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.
I learnt something new because of you... thank you..
Very usefull troubleshooting session.. Esp the datafile backup and restore to existing AG DB.
Thanks brother it is helpful 🙏👍
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?
Best best best ever!!!!many many thanks
God bless you for sharing your knowledge with us.*****
Nice Explanation Sir
nice, very helpful
so nice sir
sir i need answer for how to solve freequently deadlock issues in ms sql server? plz answer if possible
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??
Correct. You will have to restore required log backups with norecovery. Make sure, log backup jobs are disabled until the secondary is in sync.
Excellent
I have an issue our nav not connecting data base after it's suspected
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
Can database be removed from AG on primary ?
Yes, you can remove the database from the secondary and/or primary as well.
at 8:00 we can see db1 and db1_log
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.
Super.!
🎉🎉
Thanks
Hi brother can you do vedio on what are all the queries we use daily as a MSSQL DBA❤
Sure, thank you.
👌👌👌👌👌👌👌👌👌👌👌👌👌👌
Please continue Class suru kare sir live Class for ms sql administrator ka
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.
Try Hindi Series Also Please
Hi sir im interested to join the classes could you please provide your contact details
sqlwithchandu@gmail.com
Thanks