Logo
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
EPL Standings
 
 
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
- System Center Configuration Manager 2007 : Distributing Packages - Creating Collections (part 2) - Creating a Dynamic Collection
- Using Voice and Sounds : Controlling the Volume
- Windows Server 2008 : Designing the Active Directory Administrative Model (part 2) - Using Group Strategy to Delegate Management Tasks
- Exploring the Vista Task Scheduler
- Microsoft Dynamic GP 2010 : Providing clean vendor information by properly closing Purchase Orders, Protecting against information loss by printing Fixed Asset Reports
- Customizing OneNote 2010 : Customizing the Quick Access Toolbar
- Managing Windows 7 : Helping Each Other - Start the Session, Solve The Problem
- Fine-Tuning MDT Deployments : Working with the MDT Database (part 3) - Filling the MDT Database Using PowerShell
- Microsoft Visio 2010 : Creating and Using Shape Data Fields (part 3) - Saving Sets of Shape Data Fields
- Editing Digital Video with Windows Live Movie Maker (part 5) - Editing Your Video - Using Titles
Top 10
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 3) - Creating IPv4 DHCP Scopes
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 2) - Installing DHCP Server and Server Tools
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 1)
- Windows Server 2012 : DHCP,IPv6 and IPAM - Understanding the Components of an Enterprise Network
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 3) - Translating Text with the Mini Translator
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 2) - Translating a Word or Phrase with the Research Pane
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 1) - Setting Options for the Research Task Pane, Searching with the Research Task Pane
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 2) - Ending a Linked Notes Session, Viewing Linked Notes
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 1) - Beginning a Linked Notes Session
- Microsoft OneNote 2010 : Doing Research with Side Notes (part 3) - Moving Side Notes to Your Existing Notes
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro