The Easy Way to Refresh Your Dynamics GP Test Company: Part 1

By Tim Gable | October 1, 2019

The easy way to refresh your dynamics gp test company: part 1

Backing up and restoring live data on to a test company in Microsoft Dynamics GP can be a challenge if you miss a step or are unfamiliar with the process. The easy way is to automate this task by building a SQL Agent job to do the work for you.  Here is the first step to build that job.  (no SQL code writing required, SSMS must be loaded and SQL Agent running.)  This series assumes you have already created a Dynamics GP test company. Please read the notes in this article which also shows you how to create a test company if you do not have one.

1) Go to the server where your SQL Server and your Dynamics GP installation is located.

2) Launch SQL Server Management Studio and log in as SA or a user with System admin rights.

3) Start a manual backup of your live database as shown below but be sure to select your live company in place of TWO shown below.

SQL Back Up

4) When the backup setup screen opens, make the following selections:

  • Select General on the left and on the right pane check the Copy-Only backup checkbox so this process will not disrupt the existing SQL backup chain.
  • Click Remove to delete the pre-selected backup location
  • Click ADD to select a location that will not run out of space and is accessible to the SQL agent job.
  • Name the job something that is descriptive and easy to identify.  Example:  BackupOfLiveCompanyCompanyNameforRestoreOnTest.bak

  • Select the Media Options on the left pane and then the Overwrite all existing backup sets so later in the process the restore process will only have one backup to use when running multiple times.

  • Select the Backup Options on the left pane and then the compress backup to save space if your version of SQL supports this. Leave the Name as the default.

  • Now select the General page again and then the script dropdown.
  • Select the option to Scrip Action to Job

  • When the New Job window opens select name and describe the job, so it is easy to find after you save the job. Just leave the job window open when done as we will need it again later in the process.

  • Now click the ok button on the Backup Job you created as the backup file will need to exist to create the next script in our next session.

5) The next step is to change the On success action.

  • Select General from the left pane.
  • Change the set name to Backup Live GP Company Database or whatever name is appropriate if you have not already done so from above.
  • Change the dataset to your live company database, in this case, TWO. (please note this would only have effect if the job script did not name the database)

  • Now select Advanced from the left pane
  • Select On success Action drop-down and pick the “Go To The Next Step” selection.
  • Click ok and ignore any warnings.

In our next session, we will create the restore setup of this SQL job. In the meantime, if you have any other questions, reach out to us at Stoneridge Software.

Related Posts

Recommended Reading:

Stoneridge Software Selected for 2022 Microsoft US Partner Award – Dynamics 365 Business Central

Stoneridge Software is honored to be selected as a 2022 Microsoft US (MSUS) Partner Award winner for Dynamics 365 Business […]

Read the Article
6.29.22 Dynamics CRM

Reduce Manual Data & Increase Productivity with Dynamics 365 for Sales

Dynamics 365 for Sales has a ton of great features to help automate processes for you and your team to […]

Read the Article

Dynamics 365 Business Central Boolean Field Bug Temporary Fix

If you are a Dynamics 365 Business Central cloud (SaaS) customer who is using Edge or Chrome to run the […]

Read the Article

Using Non-Sequential Numbering to Prevent Locking In Your Dynamics 365 Business Central System

Running into locks in your system? Enable non-sequential numbering on your number series to prevent number series locking issues! As […]

Read the Article
6.24.22 Dynamics GP

Uncommonly Used Features: Setting Up Account Categories in Dynamics GP

This is the final part of my current series on Uncommonly Used Features in Dynamics GP. In this post, I […]

Read the Article

Increase User Productivity in Dynamics 365 Business Central with These 10 Tips

There are constantly evolving ways for you to increase user productivity in Dynamics 365 Business Central. Here are 10 tips […]

Read the Article

Star Tribune Lists Stoneridge as a Top 200 Workplace for 2022

Stoneridge Software’s emphasis on creating a positive and flexible culture has earned recognition as a top workplace in Minnesota. The […]

Read the Article
6.14.22 Dynamics GP

Uncommonly Used Features – Reconciling Sub-ledger to GL using the Reconcile Routines in Dynamics GP

As we continue the uncommonly used features series, with this post I want to show you how to reconcile your […]

Read the Article

Organize and Prioritize Your Resources with Dynamics 365 Field Service

As a manager, Dynamics 365 Field Service lets you optimize the use of your employees, their skillsets, and other resources […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!