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
- 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.
Restoring the Dynamics NAV Database
To restore the full backup, which we have created through previous steps:
Right-click the Databases → Restore Database
- 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
- Fill in the name of a new database
- Navigate to ‘Options’ and uncheck the checkboxes under Tail-log backup
- Navigate to Files and update the information file and log file as shown below
- Click ‘OK’
- Back up is restored
Best Practices for Dynamics NAV Backup and Restore
- The Complete SQL Backup of the Production should be taken weekly.
- The SQL Backup process can be automated using the SQL Server Agent.