When you are a DBA, sometimes a problem which might seem so trivial from the error description may not really be so when you dig deeper. Recently we got alerted from our monitoring system that ‘XYZ’ database was missing a differential backup with error statement as “Cannot perform a differential backup for database “XYZ”, because … Read more
One of my DBA friend was troubleshooting some issue on a SQL database server hosted on AWS EC2 Windows Instance. He was able to take remote desktop connection of EC2 instance. But as part of troubleshooting, he needed to see various details for that EC2 instance on AWS portal. He was able to login on … Read more
Issue: Recently I encountered a issue where Commvault backups for SQL databases were not happening for several days post database configuration in AlwaysOn availability groups. Scenario: In many organizations, there is a separate backup team to take all types of backups including database backups. During initial configuration there were no databases configured in availability groups and database … Read more