We are running log backup but noticed that secondary couldn’t redo the log at secondary and kept on piling the log and the drive got full.
Run below command to see what log is not clearing out
SELECT name, log_reuse_wait_desc FROM sys.databases WHERE name = 'HRDB';
Name log_reuse_wait_desc
-------- -------------------------------
HRDB AVAILABILITY_REPLICA
For short term add space or you might have to remove database from AlwaysOn Group and add it back.
In the log we see “Could not redo log record” message
Could not redo log record (40557:30625:14), for transaction ID (0:196794283), on page (1:1033), allocation unit 72058591529205760, database 'HRDB' (database ID 7). Page: LSN = (40557:30379:326), allocation unit = 72058646460891136, type = 10. Log: OpCode = 7, context 10, PrevPageLSN: (40557:30625:12). Restore from a backup of the database, or repair the database.
After troubleshooting it looks like a Bug and need to apply Cumulative patch
https://support.microsoft.com/en-us/help/3173471/fix-could-not-redo-log-record-error-and-replica-is-suspended-in-sql-se
Thanks
Satishbabu Gunukula
http://www.sqlserver-expert.com
Posts
Superb site you have here but I was wanting to know if you knew of any forums that cover the same topics discussed in this article? I'd really like to be a part of group where I can get suggestions from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Thank you! set up a website
ReplyDeleteThis sort of learning upgrades your down to earth information alongside hypothetical learning and it likewise increases the value of your resume or CV.ExcelR Data Science Courses
ReplyDeleteMediaOne has become the top website design company in singapore with their experience and expertise in the web designing arena. The experts of the agency would ensure to provide you the right web design meeting your standards without burning a hole in your pocket.
ReplyDeleteI do agree with all of the ideas you've presented in your post. They're very convincing and will certainly work. Still, the posts are very short for newbies. Could you please extend them a bit from next time? Thanks for the post. 3 room bto interior design
ReplyDeletePretty nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed surfing around your blog posts. After all I’ll be subscribing to your feed and I hope you write again very soon! event logistics Singapore
ReplyDeleteI found your this post while looking for details about blog-related research ... It's a good post .. keep posting and updating information. ashes to diamond
ReplyDeletedigital marketing courses in hyderabad by 360DigiTMG is the best one with quality training, best support and more than 9,000 Students Enrolled
ReplyDelete360DigiTMG digital marketing course
Hola! I've been reading your blog for a while now and finally got the courage to go ahead and give you a shout out from Atascocita Texas! Just wanted to say keep up the good job! paragon medical centre
ReplyDeleteWow, awesome blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is wonderful, as well as the content! List of Wastewater Treatment Companies in Singapore
ReplyDeleteMagnificent site. Plenty of useful info here. I am sending it to some friends ans also sharing in delicious. And obviously, thanks for your effort! estate planning
ReplyDeleteHi buddies, it is great written piece entirely defined, continue the good work constantly.data science course
ReplyDeleteThank you for this fascinating post, I am happy I observed this website on Google. Not just content, in fact, the whole site is fantastic.
ReplyDeleteThanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. dotcom secrets
ReplyDeleteI know this if off topic but I'm looking into starting my own weblog and was curious what all is needed to get set up? I'm assuming having a blog like yours would cost a pretty penny? I'm not very internet smart so I'm not 100% sure. Any suggestions or advice would be greatly appreciated. Cheerskose sekkisei
ReplyDeleteNice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post.
ReplyDeletemystrikingly weebly Rhinoplasty
I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.
ReplyDeletedata science course
I wanted to leave a little comment to support you and wish you a good continuation. Wishing you the best of luck for all your blogging efforts.
ReplyDeletedata science training in malaysia
The information designer is a job that will in general accompany the execution of the underlying database occasion and huge extension projects. placement cells database
ReplyDeleteMore modest activities might be served by the building range of abilities moved by the DBA. https://onohosting.com/
ReplyDelete