Logo
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
PREGNANCY
 
 
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
- Deploying Applications (part 2) - Automating Installation
- Windows Phone 8 : Working with File Explorer (part 2) - Removing Media from Your Phone
- Managing Digital Movies (part 1) - Managing Digital Movies with the Windows 7 Shell
- Microsoft Exchange Server 2010 : Managing Transport and Journaling Rules - Setting Up Message Classifications (part 1)
- Microsoft Exchange Server 2010 : Managing Connectivity with Hub Transport Servers - Send and Receive Connectors (part 2)
- Windows Phone 8 : Developing for the Phone - Application Lifecycle (part 3) - Tombstoning
- Microsoft Systems Management Server 2003 : Configuring Software Metering (part 1) - Configuring the Software Metering Client Agent
- Automating Windows 7 Installation : Customizing Images Using Deployment Image Servicing and Management (part 1) - Viewing Information about an Image with DISM
- Using the Windows 7 Libraries : USING THE EXPLORER BROWSER CONTROL (part 2)
- Microsoft Visio 2010 : Sharing and Publishing Diagrams - Saving Visio-Created Websites on a SharePoint Server
Top 10
- Sharepoint 2013 : Overview of The Client-Side Object Model and Rest APIs - Client-Side Object Model API Coverage
- Sharepoint 2013 : Overview of The Client-Side Object Model and Rest APIs - REST and OData (part 3) - Creating, Updating, and Deleting
- Sharepoint 2013 : Overview of The Client-Side Object Model and Rest APIs - REST and OData (part 2) - Filtering and Selecting
- Sharepoint 2013 : Overview of The Client-Side Object Model and Rest APIs - REST and OData (part 1) - Getting Started with REST and OData
- Sharepoint 2013 : Integrating Apps for Office with SharePoint (part 2) - Apps for Office Integrated with an App for SharePoint
- Sharepoint 2013 : Integrating Apps for Office with SharePoint (part 1) - Standalone Apps for Office
- Sharepoint 2013 : The Office JavaScript Object Model (part 3) - App Security
- Sharepoint 2013 : The Office JavaScript Object Model (part 2) - Functional Capabilities by Office Client,Mailbox-based Apps
- Sharepoint 2013 : The Office JavaScript Object Model (part 1) - Document-based Apps
- Windows Phone 8 : Playing Music Through the Phone (part 5) - Sharing Music, Playing Music Using Smart DJ, Accessing Playlists
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro