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.