Recovery Model is the most important concept in Microsoft SQL Server. Recovery model controls type of backups taken for a database. It can also control transactional log truncation and Point-in-Time Recovery of a database. On any full-fledged SQL server instance deployed on a physical server or a virtual machine, we can have various databases with … Read more
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