Managing the database
The very first daily task of a system administrator is the database backup. Other database management tasks come right behind it. The NAV administration module does not include database backup scripts - this is a task for the SQL Server. Instead of the database backup, you can export and import data from all database tables in an internal NAV format and import the file into a new database.
How to do it...
In the first recipe, we will see how to backup and restore a database with SQL Server cmdlets, then export and import NAV data via the NAV administrator shell. Besides, the recipe gives a brief overview of the PowerShell Integrated Scripting Environment.
- Run the NAV 2016 Administration Shell from the Start menu. Start the shell with administrator credentials.
- To backup the demo database, run the
Backup-SqlDatabase
cmdlet with the following parameters:Backup-SqlDatabase -ServerInstance localhost -Database "Demo Database NAV (9-0)" -BackupFile <backup...