Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
Windows Server

Microsoft Dynamics NAV : Using HotCopy backup & Testing the database

7/21/2011 4:18:39 PM

Using HotCopy backup

The HotCopy backup utility can be used to take a backup of the Microsoft Dynamics NAV database from the server location onto the hard drives.

We can use the following command prompt parameters to run HotCopy from the command prompt. Alternatively, we can also put these command-line parameters in a source file and provide that as a single parameter:

Parameter Description Example
Source Specify the path of the database, name of the database, and name of the database file (if the file is in the same folder as HotCopy.exe). We can specify multiple files as the source if we need to back up multiple databases. HotCopy source = c:\program files\Microsoft Dynamics NAV\..database.fdb.

HotCopy source=database.fdb.

(This will use the database.fdb from the HotCopy folder).
Destination Specify the path of the directory where the database file needs to be copied. If there is already a backup in the directory, it will be overwritten by HotCopy. HotCopy source = c:\.. Destination = \\Backupserver\NAVBackups\.
Dbtest This is the option to run the database test on the NAV Classic database before it is backed up. This corresponds to the File | Database | Test option. The three options are minimum, maximum, and normal. HotCopy source = c:\..Destination = \\Backupserver\NAVBackups\ dbtest = maximum.
CC This parameter is used to specify if a consistency check needs to be performed on the backup. This check performs a bit-by-bit comparison of the original database with the backup taken. HotCopy source = c:\.. Destination = \\Backupserver\NAVBackups\ dbtest = maximum CC= yes.
Description Use this parameter to give a description of the backup. HotCopy source = c:\..Destination = \\Backupserver\NAVBackups\dbtest=maximum CC= yes.
Servername This is the name of the Dynamics NAV Classic database server. The default is local host. HotCopy source = c:\..Destination = \\Backupserver\NAVBackups\dbtest=normal CC= yes servername = NAV2009
Osauthentication We can use this parameter if we intend to use Windows Authentication. The only option is either "yes" or specify the username and password as defined in the subsequent parameters. Hotcopy source = c:\..Destination = \\Backupserver\NAVBackups\dbtest=normal CC= yesServername = NAV2009 Osauthentication = yes
User Enter the username for the user creating the backup, if Windows authentication is not used.  
Password Enter the password for the user creating the backup, if Windows authentication is not used.  
Nettype Specify the network type used between database server and clients. The options are netb for NetBIOS, tcps for TCPS, and tcp for tcp/ip.  

HotCopy creates an exact snapshot of the database files in the specified destination folder. To restore the database backup created using HotCopy, copy the backed up files (.fdb) to the database folder and restart the database server.

Testing the database

Running periodic tests on the Dynamics NAV database must essentially be a part of the organization's periodic database management plan.

The backup process in Dynamics NAV has a built-in basic database test, which runs during the backup process.

To run a database test on the Dynamics NAV database, go to File | Database | Test.

Starting the test

The following options can be selected before starting the test:

  • Minimum: This is the test that the Dynamics NAV backup process automatically initiates. This includes testing primary keys and data, and also testing all BLOB fields in the database. When run, this test validates the data in the primary keys, which is readable and sorted appropriately, and all the BLOB fields in the database can be read.

  • Normal: In addition to the checks done in the Minimum DB tests, this test also checks for secondary keys and space allocation.

  • Maximum: This test includes testing for field relationships in addition to the tests available in Normal.

  • Custom: This feature allows us to configure a test by selecting any of the tests from the list.

On the SQL Server database, most of these tests involve running the SQL Server Database Consistency Checker (DBCC).

Viewing the output of the database

Output of the database can be viewed using the following different options, which can be selected from the Options tab of the Test Database window:

  • Screen: Selecting this option would pop up error messages during the running of the database test. User intervention will be needed to continue the test beyond the displayed error message.

  • Event Log: This option, if selected, would display the error messages in the event log of the server.

  • File: This option will output all error messages in a text file. The location of the text file must be specified in the File Name field below this option.

Other -----------------
- Microsoft Dynamics NAV : Creating and restoring backups using a Dynamics NAV client
- Microsoft SQL Server 2008 Analysis Services : Building Basic Dimensions and Cubes - Setting up a new Analysis Services project
- Windows Server 2008 Server Core : Managing IIS - Working with the ApplicationHost.CONFIG File
- Microsoft Dynamics CRM 2011 : Creating a Dynamic Marketing List
- Microsoft Dynamics CRM 2011 : Evaluating Members Included in a List by Using Advanced Find & Removing Selected Members from a List
- Microsoft Dynamics AX 2009 : The MorphX Tools - Label Editor
- Windows Server 2008 R2 : Manage a DNS Server (part 3) - Manage Zone Database Files & Configure Single-Label DNS Resolution
- Windows Server 2008 R2 : Manage a DNS Server (part 2) - Manage DNS Integration with Active Directory & Change Zone Replication
- Windows Server 2008 R2 : Manage a DNS Server (part 1) - Change the Address of a DNS Server & Scavenge Properties for DNS
- Active Directory Domain Services 2008 : Manage Active Directory Domain Services Data - Reset a User Account Password
- Active Directory Domain Services 2008 : Manage Active Directory Domain Services Data - Enable a User Object
- SQL Server 2005 : Privilege and Authorization - Data Organization Using Schemas
- SQL Server 2005 : The Principle of Least Privilege
- Microsoft PowerPoint 2010 : Setting Advanced PowerPoint Options
- Microsoft PowerPoint 2010 : Setting General PowerPoint Options
- Business Server 2011 : Protecting the Power Supply
- Planning Your Small Business Server 2011 Network : Choosing Naming Conventions & Planning for Security
- Microsoft Dynamics GP 2010 : Developing connections with Internet User Defined fields
- Microsoft Dynamics GP 2010 : Getting clarity with User Defined fields
- Performing Daily Exchange Server 2003 Monitoring and Maintenance (part 3) - Configuring Diagnostic Levels and the Monitoring And Status Utility
Most view of day
- Local Continuous Replications in Exchange Server 2007
- Windows Server 2003 on HP ProLiant Servers : The Physical Design and Developing the Pilot - Network Services
- SharePoint 2013 Request Management (part 1) - The Request Management Process
- Microsoft LynServer 2013 : Firewall and Security Requirements - Reverse Proxy Requirements
- Microsoft Systems Management Server 2003 : Queries (part 2) - Creating a Query
- Windows Server 2012 : Configuring IPsec (part 6) - Configuring connection security rules - Creating a custom rule, Configuring authenticated bypass
- Windows Server 2008 : Designing the Active Directory Administrative Model (part 3) - Planning to Audit AD DS and Group Policy Compliance, Planning Organizational Structure
- Creating DVD Movies with Windows DVD Maker (part 6) - Changing Other DVD Options - Customizing the Menu , Configuring the Photo Slide Show
- How to Troubleshoot Driver Problems (part 3) - How to Use the File Signature Verification, How to Use Device Manager to View and Change Resource Usage
- Microsoft Visio 2010 : Linking External Data to Shapes (part 4) - Using the Database Wizard - Taking the Data-Linked Light Bulb Shape for a Spin
Top 10
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
- MDT's Client Wizard : Application Properties
- MDT's Client Wizard : Operating System Properties
- MDT's Client Wizard : Customizing the Deployment Share
- Windows Server 2012 : Software and User Account Control Administration (part 5) - Maintaining application integrity - Configuring run levels
- Windows Server 2012 : Software and User Account Control Administration (part 4) - Maintaining application integrity - Application access tokens
- Windows Server 2012 : Software and User Account Control Administration (part 3) - Mastering User Account Control - Configuring UAC and Admin Approval Mode
- Windows Server 2012 : Software and User Account Control Administration (part 2) - Mastering User Account Control - Elevation, prompts, and the secure desktop
- Windows Server 2012 : Software and User Account Control Administration (part 1) - Software installation essentials
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro