Starting in Microsoft Dynamics GP 2013 R2 the Back Up Company and Restore Company windows, found under Microsoft Dynamics GP, then Maintenance and then Backup and Restore, have been changed to allow users to use a Microsoft Azure Storage Blob to hold their Microsoft SQL Server database backups. Both windows have been changed to add the Use Microsoft Azure storage option:

image

Prerequisites

First, if you attempt to select the option when Dynamics GP 2013 R2 is running on a build of Microsoft SQL Server prior to 2012 SP1 CU2 (build 11.00.3339) you will receive the following message:

image

The other prerequisites involve the configuration of Microsoft Azure itself, and those steps include:

1) Create a Microsoft Azure Storage Account:

a. http://azure.microsoft.com/en-us/documentation/articles/storage-create-storage-account/

2) Create a Blob Container:

a. http://msdn.microsoft.com/en-us/library/74edd1fd-ab00-46f7-9e29-7ba3f1a446c5

 

Using Windows Azure Blob Storage in Microsoft Dynamics GP 2013 R2

In order to utilize the Use Microsoft Azure storage option to store your Dynamics GP database backups you need to do the following:

1) In the Azure Dashboard:

a. Create a Storage Account

b. Create a Blob Container

2) Log into Dynamics GP 2013 R2 as a user who is also an administrator in SQL Server.

3) Navigate to Microsoft Dynamics GP, then Maintenance, then Backup or Restore.

4) Mark Use Microsoft Azure storage.

5) Browse to the storage account you created in step 1. Select the Containers tab on the top of the page, make note/copy the URL field. This will go in the URL to containerfield on the Dynamics GP Backup and Restore windows.

image

6) From the bottom center of the web page, click MANAGE ACCESS KEYS. The storage account information is displayed. The STORAGE ACCOUNT NAME and PRIMARY ACCESS KEY will be required in the Storage account name and Access keyfields on the Dynamics GP backup and restore windows. 

image

image

7) Click Verify Accountto ensure your information is correct. You will see the following if the test is successful:

image

8) Note the File Namethat will be used and change it if necessary.

9) Click OKto backup or restore the database.

 

We hope you’re as excited about this new functionality as we are here on the team.

Click HERE for detailed documentation and VIDEO!!!

Enjoy!