What Is The Best Backup Strategy for Dynamics 365?

Many organizations plan their Microsoft Dynamics 365 deployment and spend a significant amount of money deploying it but fail to make a backup maintenance plan. As a Dynamics 365 expert, you must be able to come up with a proper backup that will not slow down or interfere with performance or work.

Data loss can happen in several ways:

Computer/Virus attacks
Human error
System /Hardware Malfunctioning
Software Corruption
Natural Disaster

What to consider when planning a Dynamics 365 database backup?

Backup location:

Avoid having your backup at the same site as your Dynamics 365 database. Although it’s convenient to have the backup close by, human errors or virus attacks on your site or network will render the backup pointless. If there is any disaster, both your database and backup could be affected. It’s better to take the time to restore your backup than to end up with nothing.

Proper backup schedule:

Schedule your backups in such a way to minimize data loss. This could range from hourly to weekly. Backup as often as you deem fit, depending on the frequency and volume of your work. In any case, it’s wise to perform a backup frequently. You can either schedule to run the backup automatically or manually.

Create an emergency recovery plan:

Nobody wishes for a reason to perform a recovery, but that’s the reason why we backup in the first place. No matter the cause of data loss, you must lay out a plan for recovery.

Test your backup and recovery strategy:

After creating your backup and recovery plan, run through the recovery plan to ensure that if a failure occurs, you can recover as much data as possible. We also recommend checking if your backup policy backs up the correct data (Do a test restore to a test database to ensure your backup works as expected).

Adequate resources on a database server:

Ensure that you have enough memory and CPU on the SQL server to cope with the workload, so a backup does not affect performance and productivity.

Which backup method is the best to do?

To determine which backup method to use, get acquainted with the various backup methods, such as when and how to use them. As a side note, a Dynamics 365 database backup is best carried out using SQL Server Management Studio.

Your backup method will mainly depend on how large your database is and the rate at which it grows. Let’s take a look at the backup methods available:

Full Backup

This is the starting point of all other backups as it contains the full copy of your data files in the database. However, it is time-consuming and best done when the database is not too large.

Differential Backup

This backup contains all the changes in the data files from a previous full backup. Although, over time, a differential backup may become larger than the original full backup. When restoring, the full backup (base) is restored first and then followed by the most recent differential backup.

Transaction Log Backup

A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file. With transaction log backups, you can recover the database to a specific point in time (for example, prior to entering unwanted data), or to the point of failure. A full backup must be done first before transactional log backups can be carried out.
Dynamics Transaction Log Backup

How do you perform a backup?

Open SQL Management Studio on the system running Microsoft SQL Server
Log in using  a user that has access to your Dynamics 365 database
Expand the Databases
Right-click on the database you wish to backup, then select Tasks -> Backup
On the popup window, ensure that the selected database is the right one
Choose your preferred backup plan
Select your destination folder
Click on Ok and wait for your database to complete.
Please Note: Change the default destination folder; otherwise, it will save to the same location as your data files, and the whole idea of backup will be defeated.

Also, you can schedule a backup to run at any specific time you wish.

Create a SQL Server scheduled backup by using SQL Server Maintenance Plan
Expand Management in SQL Management Studio
Right-click on Maintenance Plan and select Maintenance Plan Wizard
Give it your preferred name and click Next
In the Select Maintenance Plan Tasks, select the Backup Database option and the Check data integrity option. (The check data integrity task performs internal consistency check of the data and index pages within the database)
Then configure the maintenance task by specifying a database for backup and the backup options. In the Define Backup Database Task window also check the Verify backup integrity option.
Note: Verify that the SQL Server Agent service is running and set to automatic. The maintenance plan depends on this service to run.
No matter the backup plan you decide on, use the right strategy and follow best practices for backing up your Dynamics 365. This will help you avoid the monetary and productivity loss associated with CRM disaster recovery.


Popular posts from this blog

How to Query Microsoft Dataverse Data using SQL from Power BI or SSMS

Users Unable to See Flow Button and run On Demand workflows in Dynamics 365 CE

How To Deploy Dynamics App For Outlook (On-Premise)