BuyDomino Search MyDomino Portals Change Region Menu

Domino Automation - How to backup SQL database and Domino Automation project (.bak)

Safety Note

This document applies to:

  • The Domino Printing Group
  • The IT department of Domino's clients
  • End-users of the Domino Designer software
  • End-users of the Domino Automation software.

Description

This document aims to present the various backup methods to be implemented in order to ensure the continuity of the Domino Automation system and its database. Domino Automation 300 utilises a SQL Express database.

It is important to back up the system and the database (DB) on a daily basis. It is suggested to combine:

  • Instant snapshots using Snapshots (managed by the client's IT department)
  • Manual or automatic backups of your database (client's responsibility)

✍️ NOTE

In the event of a server or server workstation crash, having a complete backup of your database is extremely useful and can save a lot of time. Without backups, you would need to reinstall and reconfigure the entire system from scratch. It is your responsibility and that of your IT department to back up your server and database.

Step 1

MANUAL SQL BACKUP (.bak)

✍️ NOTE

In this scenario, the project name "DA_RSERIES" will be backed up.

 

  1. Open SQL Management Studio



  2. Connect to the instance



    Several possibilities to enter in "Server Name" for the connection

    SERVER_NAME\INSTANCE_NAME
    SERVER_IP\INSTANCE_NAME

  3. After connecting, the following page appears



  4. Left-click on the "+" located next to "Databases"



    You need to backup both the database and the metrics database, ie: DA_RSERIES & DA_RSERIES_Metrics

  5. Right-click on DA_RSERIES / Tasks / Back Up …



  6. Verify backup directory and click “OK”



    The following message will confirm whether the backup worked:



  7. You may verify the directory itself:



  8. Right-click on "DA_RSERIES_Metrics", then "Tasks", then "Back Up…"



  9. Verify backup directory and click “OK”



    The following message will confirm whether the backup worked:



  10. You may verify the directory yourself:



  11. The database and project has succesfully been backed up using the .bak methodology.

Attachments