Monthly Archives: October 2019

Read-only URL removal

When I blog to configure Read only replica. it would require to provide read-only URL information, and provide the replica sequence. but their is no easy way to remove the Read-only URL. we have to remove the AG group to … Continue reading

Posted in Disaster Recovery, High Avaliability, Others | Tagged , , | Leave a comment

Error 9002

This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance jobĀ  failed or you system not respond properly. for update stats you get so … Continue reading

Posted in Error Log, Others, Transaction Log, Troubleshooting | Tagged , , | Leave a comment

Fail to cycle errorlog

sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle the errorlog it will fail.   and we get error that … Continue reading

Posted in Error Log, Others, What I learned today | Tagged | Leave a comment

Read-only Replica -AG

Read only replica is a great concept where we can re-direct all the read only connections to that replica.   Following are some of the great articles for it. How to Configure Read-Only Routing for an Availability Group in SQL … Continue reading

Posted in Disaster Recovery, High Avaliability, Others, What I learned today | Tagged , | Leave a comment