Strangely all the replicas appear to be up to date. You crack open a SQL script and run it against the primary to see which replica is running behind. Availability Groups – the lifesaver of your organization and the bane of your nightmares. Ever the vigilant person you logon, crank open SSMS or ADS and take a look at sys.databases to check out the log_reuse_wait_desc.ĪVAILABILITY_REPLICA the DMV proudly advises. One day you’re happily working away and get interrupted by an alert that says your transaction logs are getting full or maybe growing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |