Always ON

SSISDB considerations while upgrading/patching SQL Server

by

Issue Description: While patching SQL server sometimes SQL services fails to come online post patching. It may be due to various reasons like any corruption in system databases, script level upgrade failure for system databases etc. In this post, we will talk about issues that may arise if you have SSISDB (SQL server integration services … Read more

Commvault SQL database backups not running after databases configuration in AlwaysOn groups

by

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