Logo
PREGNANCY
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
- Microsoft Systems Management Server 2003 : Analysis and Troubleshooting Tools - Using SMS Trace (part 2)
- Windows Phone 8 : Scheduled Tasks - Updating Tiles Using a Scheduled Task Agent
- Deploying Applications (part 2) - Automating Installation
- QuarkXPress 8 : Checking spelling (part 1) - Running a spell check, Creating custom spelling dictionaries
- Installing and Configuring the Basics of Exchange Server 2013 for a Brand-New Environment (part 2)
- Managing Client Protection : Microsoft Forefront Client Security
- Working with E-mail, Contacts, and Events : Create a Contact Category
- Using Voice and Sounds : Directing Your Computer with Voice Commands, Dictating Text
- Managing Windows 7 : Managing Windows Arrangements, Changing Search Options
- Windows Phone 7 : Running XNA Projects in Windows (part 5)
Top 10
- Windows Phone 8 : Configuring Mailbox Settings (part 5) - Configuring Automatic Replies
- Windows Phone 8 : Configuring Mailbox Settings (part 4) - Lightening the Display,Changing the Mailbox Sync Settings
- Windows Phone 8 : Configuring Mailbox Settings (part 3) - Message Signatures, Blind CCing Yourself
- Windows Phone 8 : Configuring Mailbox Settings (part 2) - Unlinking Mailboxes, Conversation View
- Windows Phone 8 : Configuring Mailbox Settings (part 1) - Linking Mailboxes
- Managing Windows Server 2012 Systems : Configuring Roles, Role Services, and Features (part 6) - Tracking installed roles, role services, and features
- Managing Windows Server 2012 Systems : Configuring Roles, Role Services, and Features (part 5) - Installing components at the prompt
- Managing Windows Server 2012 Systems : Configuring Roles, Role Services, and Features (part 4) - Managing server binaries
- Managing Windows Server 2012 Systems : Configuring Roles, Role Services, and Features (part 3) - Adding server roles and features
- Managing Windows Server 2012 Systems : Configuring Roles, Role Services, and Features (part 2) - Installing components with Server Manager - Viewing configured roles and role services
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro