Share This Post

NAV Updates

Backup and Restore NAV Database Using SQL Server

This article will help you to Backup and Restore NAV Database Using SQL Server.

How to Backup and Restore

The database is one of the most valuable assets of any company. To ensure that you keep your information safe, backups are essential.

After the release of Navision 2013 R2, the Microsoft discontinued the Microsoft Dynamics NAV backup feature. The additional option was included to allow for import/export of information in NAV 2013 R2, but doing a backup using the Import/Export Data feature is time-consuming. For a complete backup, the SQL Backup is the best and the fastest option.

Creating the Full Backup From the SQL Server Management Studio

  • Open SQL Server Management Studio from the menu
  • Navigate to Database for which you want to create the backup

Right-click the Database. Select Tasks → Backup

SQL Server Management Studio

SQL Server Management Studio

  • To create the full backup, choose ‘Full’ in Backup type.
  • Select where to save the backup file using the Add button under Destination.
  • Under Options choose to Verify backup when finished to ensure that all the files in the backup are readable and can be restored.
  • Click ‘Ok’. Backup File will be generated in the mentioned location.
SQL Server Backup Window

SQL Server Backup Window

Restoring the Dynamics NAV Database

To restore the full backup, which we have created through previous steps:

Right-click the Databases → Restore Database

Restore Options

Restore Options

  • Select ‘Device’ and click the Assist-Edit button.
  • Click ‘Add’ and navigate to the destination where the backup file is stored
  • Select .bak file and click ‘OK’
  • Click ‘OK’ in ‘Select backup devices’ window
Backup File Restore

Backup File Restore

  • Fill in the name of a new database
  • Navigate to ‘Options’ and uncheck the checkboxes under Tail-log backup
 Option Restore Window

Option Restore Window

  • Navigate to Files and update the information file and log file as shown below
  • Click ‘OK’
  • Back up is restored
Database restore

Database restore

Best Practices for Dynamics NAV Backup and Restore

  1. The Complete SQL Backup of the Production should be taken weekly.
  2. The SQL Backup process can be automated using the SQL Server Agent.

Share This Post

Leave a Reply

Notify of
Skip to toolbar