Skip to main content


Showing posts with the label Automated Backups

Setup SQL Server Backups for Business Central On-Premise

Introduction: After having a successful implementation of Business Central On-Premise for the client's environment, it is necessary to automate administrative tasks such as Database Backups and restoration policies to Ensure Business Continuity and Disaster Recovery. Pre- requisites : Understanding of SQL Backups -Full Backups: - Differential Backups: - Transactional Backups: Understanding of PowerShell Demonstration: In this blog, it is necessary that you understand the different backup types. Just to give a hint below is a one-line explanation. i. Full Backups: Takes a full backup of DB ii. Differential Backups: After the full backup takes the change in data is added to the differential backup iii. Transactional Backup: After the last backup, the tra