Backup and Restore a Database using the NAV Client (2009 / 2013)

,

Backup and Restore a Database using the NAV Client (2009 /2013)

One method of Backing up and Restoring a database is using the Navision Classic Client. This however can take longer to do (in terms of processing) and can cause table locking – so is not recommended for working hours. 
Note: The best method of doing a backup is via the SQL Server Management Studio (covered in another post). 
To perform a backup of the database you must do the following: 
1. Open the relevant Database.
2. Tools >> Backup… >> Select the relevant companies (or Entire DB) >>  Always select Objects/ Data common to all companies >> Add a Description >> Choose a location to save >> OK
 To restore a database do the following: 
1. Open the Database (whether it be empty or already populated). 
2. Tools >> Restore… >> Select the relevant backup file  >> OK.

The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix