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.
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 file...