Maconomy Enterprise Cloud Online Admin Guide

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Recurring Database Copies

You can purchase a recurring database copies add-on that you can set up from one environment to another.

You may want to set up recurring database copies from one environment to another. For example, you may want to have weekly copies from Production to Production Support so that Production Support is always a recent replica of Production. If you would like to set up recurring database copies, you can purchase a recurring database copies add-on. The available options are Daily, Weekly or Monthly.

Note: Recurring Database Copies will apply a recent copy (within 24 hours) of your Production database to a chosen Non-Production database. This add-on cannot be used to re-apply older standing copies of the Production Database to a Non-Production database. If you would like to preserve User Access Rights in the Non-Production system and not have them reflect Production, please speak to Deltek Professional Services about engaging them to set up a Background Tasks for this protected by System Natures.

DB Copies will be scheduled to run outside of main office business hours. For example, if you request a database copy on the 10th March, the copy will commence after business hours on the 10th March and will complete before business hours start on the 11th March.

Note: As part of the database copy process any active connections to the database where the copy is being applied will be terminated.

Once a Recurring Database Copies add-on is purchased, you will need to notify the Deltek Cloud Ops team that you are ready for the recurring copies to be set up. Please be advised that there is a lead time of 3 business days for any schedule to be set up.

You can submit your request as a Support Case in the Deltek Support Center using the template below:
  • Create a Scheduled Recurring Database Copy
    1. Open Deltek Support Center and click on Submit Case
    2. Use the following template to raise your RNT ticket:
      • Product > Maconomy – Maconomy Solutions
      • Severity Level > S4 – General
      • Issue Type > Technical
      • Summary > “FAO DCO: Create a Scheduled Recurring Database Copy”
      • Detail >

        “We have purchased an add-on for Recurring Database Copies in the Enterprise Cloud. Please activate the scheduled copies using the following information:

        Frequency Purchased: Daily/Weekly/Monthly (delete as appropriate)

        Start Date of Schedule: DD/MM/YYYY

        Non-Production Environment where Database Copy should be applied: _________

    3. Click Continue and then click Finish Submitting Case.

Recurring Database Copies can be paused as required. In order to pause a recurring database copy you will need to raise the Pause Database Copy service request. Details of this Service Request can be found in the Service Requests section.

Note: The binary documents table will not be included in the database copy as standard. This will ensure that the DB copy is a manageable size. To request that a specific copy include the binary documents table please raise a Support Case through the Deltek Support Center to request this.