Logo
PREGNANCY
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows Server

Microsoft Dynamics NAV : Backing up and restoring with SQL Server

7/21/2011 4:22:05 PM
If we are using the Dynamics NAV SQL Server option, the recovery plan for our backups will depend a lot on the recovery model we have selected for the database.

We can change/select the recovery model for the Dynamics NAV SQL database either from the SQL Server management studio, or from the Alter Database window in the Dynamics NAV application, as shown in the following screenshot:

We have the following options for the Recovery model:

  • Bulk-logged: The transaction log will contain information only about the large transactions. This model provides support against disk failure and does not affect the performance as much as the Full mode does.

  • Full: The advantage that full log has over all other models is that it guarantees the recovery of the database to the point of failure. It is advisable to use this method for production databases, provided the resources are available to do so. It is the most flexible method for recovery and takes the most transaction log space, and using this method, the last committed transaction can also be recovered.

  • Simple: This is the easiest and the least resource-hungry of all recovery types. The recovery of the database is limited to the last backup taken. It is recommended to be used for development databases or non-production databases, where recovery of data is not critical.

The client backup for SQL Server option remains the same as it is in the C/SIDE or Classic version of Dynamics NAV.

SQL Server gives a lot of flexibility in terms of database backup, restore options, and the options for backup media (such as tapes, drives, or other backup devices). It also provides the ability to overwrite backups and perform incremental/differential backups. Generally, SQL backup can be done while transactions are being done on the database.

Creating a server-side SQL backup

Let's walk through the process of creating a server-side backup of the Dynamics NAV database as follows:

  1. 1. Go to SQL Server Management Studio and from the Object Explorer, highlight the Dynamics NAV database, as shown in the following screenshot:

  1. 2. Right-click on the database and navigate to the Back Up... menu, as shown in the following screenshot:

  1. 3. Select Full in Backup type, and add a name for the backup and an appropriate description.

  2. 4. Click on the Add button and select the Disk option under Destination and input the filename and name of the directory in the File name field under Destinations on disk, where we would want to store the backup.

  3. 5. A message similar to the following screenshot is displayed after the backup is successfully completed:

Restoring the SQL backup

Let's walk through the process of restoring the SQL backup as follows:

  1. 1. To restore the SQL backup, right-click on the Database(s) item on the SQL Server and click Restore.

  1. 2. Enter the name of the new or existing database in the To database field.

  1. 3. In the Source for restore, select the From device option.

  1. 4. To select the backup files created in the previous backup process, click on the Assist Edit button in the From device field.

  2. 5. Then click Add and select the backup file from the location on the drive.

There are some key differences between the SQL Server backup and the backup done by using the Dynamics NAV client.

The ability to back up specific Dynamics NAV companies is one of them. The ability to update only data (not the application objects) is also a key differentiator available in the Dynamics NAV client-based backup.

SQL Server on the other hand supports transaction log backup, file/file group backup to back up individual files, and differential backups, apart from the standard full database backup. As a SQL Server backup is server-based, it is faster than the Dynamics NAV client-based backup.

For more detailed information on using SQL backups, it is recommended to review the documentation for Microsoft SQL Server.
Other -----------------
- Microsoft Dynamics NAV : Using HotCopy backup & Testing the database
- 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
 
 
Most view of day
- SQL Server 2008 R2 : Advantages of Stored Procedures, Creating Stored Procedures
- Windows Server 2003 on HP ProLiant Servers : Active Directory Logical Design - Replication Topology (part 2)
- SQL server 2008 R2 : Reverting to a Database Snapshot for Recovery
- Sharepoint 2013 : Integrating Apps for Office with SharePoint (part 2) - Apps for Office Integrated with an App for SharePoint
- Maintaining Desktop Health : Monitoring Reliability and Performance (part 3)
- Using the Windows 7 Libraries : CONSIDERING USER-DEFINED COLLECTIONS
- Sharepoint 2013 : Create a Team Site, Create an Enterprise Wiki Site in SharePoint Server, Create a Blog Site
- Windows Phone 8 : Designing for the Phone - Blend Basics (part 1) - Layout
- Creating DVD Movies with Windows DVD Maker (part 1) - Adding Photos and Videos to Your DVD Project
- Working with the User State Migration Tool (part 1) - Using the USMT in Four Deployment Scenarios
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