Wednesday, June 18, 2014

NAV 2013 R2 - How to Backup Selected companies - Powershell (Using Service Tier).

Hi all,

In this post we will list down the steps to take backup using power shell & Service Instance.

If you haven't read the Previous post, please refer to Index of Posts.

We will see usage of below listed 3 & 4 Commandlet options in this post.

3. UseNST_AllCompanies
4. UseNST_SomeCompanies

Let's see how to use each of them.



3. UseNST_AllCompanies

* Remember the Service Instance Should be Running and Available.

Below are parameters of the command-lets 3 -

1.  All Companies - You want to backup all companies or not.
2.  File Name - The File Path and name where you want to store the backup (ends with Extension => .navdata).
3.  ServerInstance - Service Name which is connected to Database which we want to backup.
4.  Description - Description to file that you want to give.
5.  Include Application - Want application objects or not.
6.  Include Application Data - Want  data that defines the application in the database.
7.  Include Global Data - Want Data common to all companies or not.
8.  Tenant - Used in Multitenat (Will Discuss Later in Separate Post)

As shown below is the parameters set for the backup.



Below is the command generated for the all companies backup.
-------------------------------------------------------------------------
Export-NAVData -AllCompanies -FileName c:\All_Comapniesbackup_Service.navdata -ServerInstance DynamicsNAV71 -Description "This is all companies backup using service tier." -IncludeApplication -IncludeApplicationData -IncludeGlobalData
-------------------------------------------------------------------------
Run the command and backup will be placed as shown below.



4. UseNST_SomeCompanies

* Remember the Service Instance Should be Running and Available.
* In this script we skip the application objects and global data.

Below are parameters of the command-lets 4 -

1.  File Name - The File Path and name where you want to store the backup (ends with Extension => .navdata).
2.  ServerInstance - Service Name which is connected to Database which we want to backup.
3.  CompanyName - Name of Company you want to backup (if multiple put them as comma separated).
    * Multi Character Name should be in ''. 
4.  Description - Description to file that you want to give.
5.  Include Application - Want application objects or not.
6.  Include Application Data - Want  data that defines the application in the database.
7.  Include Global Data - Want Data common to all companies or not.
8.  Tenant - Used in Multitenat (Will Discuss Later in Separate Post)

As shown below is the parameters set for the backup.



Below is the command generated for the all companies backup.
-------------------------------------------------------------------------
Export-NAVData -FileName c:\Two_Comapniesbackup_Service.navdata -ServerInstance DynamicsNAV71 -CompanyName B,'CRONUS International Ltd.' -Description "This is two companies backup using service tier without Global data." -IncludeApplicationData
-------------------------------------------------------------------------
Run the command and backup will be placed as shown below.



I hope you are able to understand the concept discussed above. In Next post we will see how to Take Backup from Windows Client.

Regards,
Saurav Dhyani

No comments:

Post a Comment