BuyDomino Search Changer de région Menu

Domino Automation - How to backup SQL database and Domino Automation project (.mdf & .ldf)

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 (.mdf & .ldf)

✍️ NOTE

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

 

  1. Open Window's "Services" with administrator's privileges

  2. Search for "SQL Server (INSTANCE_NAME)"

    Instance name: DASQL



  3. Right-click, then click "Stop" the service



  4. Open File Explorer



  5. Navigate to the directory:

    C:\Program Files\Microsoft SQL Server\MSSQLXX.INSTANCE_NAME\MSSQL\DATA

    Example of path:



    The directory contains several .mdf and .ldf files

  6. Copy the following 4 files:



  7. Paste the files into a storage device or backup directory



    Result:



  8. Open Window's "Services" again

  9. Right-click on "SQL Server (INSTANCE_NAME)", then click "Start Service"



  10. The system has been sucesfully backed up using .mdf & .ldf methodology.

Attachments