SQL Server Backup

SQL Server Encrypted Backup and Restore

by

SQL Server encrypted backup is a feature of both standard and enterprise edition in SQL Server 2019. You can refer below link for more details: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver15 Taking encrypted backups and restoring those backups on another SQL instance requires some additional steps to be followed. Take Encrypted Backup Above encrypted backups could be restored on same … Read more

Taking SQL Server Backups in yyyymmdd_hhmmss format

by

When we configure native log shipping, it takes log backups in yyyymmdd_hhmmss format. Recently, we had requirement where customer wanted us to take other native backups in yyyymmdd_hhmmss format. We used below code for taking different backups in required format. Full Backup Differential Backup Log backup

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