Skip to main content

Posts

Showing posts with the label SQL Backup

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: https://www.mssqltips.com/sqlservertutorial/7/sql-server-full-backups/ - Differential Backups:https://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/ - Transactional Backups: https://www.mssqltips.com/sqlservertutorial/8/sql-server-transaction-log-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