Skip to main content

How to Backup and Restore NAV Database Using SQL Server

How to Backup and Restore 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 Okello Dan +256775120005

Comments

Post a Comment

Popular posts from this blog

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your...
Post a Comment
Read more

How to install a Microsoft Dynamics NAV cumulative update

How to install a Microsoft Dynamics NAV 2018 cumulative update Introduction This article describes how to install a cumulative update for Microsoft Dynamics NAV 2018. You have to recompile all objects after you install a cumulative update. A cumulative update is a cumulative set of files that includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018. A cumulative update includes files that are separated into the following folders: APPLICATION DVD See  Upgrading the Data to Microsoft Dynamics NAV 2018  for details. How to install the cumulative update files APPLICATION The APPLICATION folder includes the following files: AccumulatedChangeLog.<Locale>.<Build No.>.txt Changelog.<Locale>.<Build No.>.txt CUObjects.<Locale>.<Build No.>.fob Objects.<Locale>.Objects.<Locale>.<Build No.>.txt To install the application files, fol...
Post a Comment
Read more

Microsoft Dynamics NAV 2017 Architecture

Microsoft Dynamics NAV 2017 Architecture An entire book could be written, and likely has, on the Microsoft Dynamics NAV 2017 architecture and how to design the on premise infrastructure to host it. To help you get the most out of this software, and to understand the foundation on which it has been built, this blog provides a summarized version of Dynamics NAV 2017’s complex architecture. Three-Tier System Microsoft Dynamics NAV 2017 is a three-tier (or three-layer) architecture system. It consists of: presentation tier logic or business processing tier database management system tier The presentation tier consists of the NAV Windows Client (formerly RTC), the NAV Web Client, the NAV Tablet/Phone Client (Universal App), and the NAV Development Environment. The business logic-processing tier is where the NAV code is executed and is called the NAV Service Tier or NST for short. The database management system tier is SQL Server. In the older two-tier (2009 and older) arc...
Post a Comment
Read more