Skip to content

How to Backup and Restore NAV Database Using SQL Server How to backup and Restore Dynamics NAV database using SQL Server

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

After the release of NAV 2013 R2, Microsoft discontinued the NAV Database backup (.fbk) feature. An additional option was added to allow for import/export of data in NAV 2013 R2, but doing a backup using the Import/Export Data feature is time consuming. For a complete Database backup, SQL Backup is the best and fastest option.

Creating a Full Backup From SQL Server Management Studio

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

Right click the Database. Select Tasks → Backup

Figure 1 - Select Backup from SQL Server Management Studio
Figure 1 - Select Backup from SQL Server Management Studio

  • To create a full backup, select ‘Full’ in Backup type
  • Choose where to  save the backup file using ‘Add’ button under Destination
  • Under Options select ‘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 specified location

Figure 2 - Options in the SQL Server Backup Window
Figure 2 - Options in the SQL Server Backup Window

Restoring the Dynamics NAV Database

To restore a full database backup, which we created through previous steps:

Right click the Databases → Restore Database

Figure 3 - Restore Database Options
Figure 3 - Restore Database Options

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

Figure 4 - Select the Backup File to Restore
Figure 4 - Select the Backup File to Restore

  • Fill in the name of new database
  • Navigate to ‘Options’ and uncheck the check boxes under Tail-log backup

Figure 5 - Rename the Database and the Option Restore Window
Figure 5 - Rename the Database and the Option Restore Window

  • Navigate to ‘Files’ and update the data file and log file as shown below
  • Click ‘OK’
  • Database is restored

Figure 6 - Rename File Window for Database
Figure 6 - Rename File Window for Database

Best Practices for Dynamics NAV Database Backup and Restore

  1. A Complete SQL Backup of Production database should be taken weekly (over the weekend)
  2. The SQL Backup process can be automated using a SQL Server Agent

If you have any questions about this function or other Dynamics NAV questions for any version, contact ArcherPoint.

Read more "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.

If you are interested in NAV development, check out our collection of NAV Development Blogs.

Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube