BuyDomino Search MyDomino Portals Change Region Menu

Domino Automation - How to Migrate Server (.mdf & .ldf)

Safety Note

This document applies to:

  • The Domino Printing group
  • The IT department of Domino's customers
  • The end user of the Domino Designer software
  • The end user of the Domino Automation software

Description

This document aims to outline the steps to migrate a Domino Automation 300 system, including the SQL Express database, from an old server to a new server.

✍️ NOTE
  • Administrative rights are required to perform migration operations.
  • The new server will need to be restarted.
    • It's important to plan accordingly, either by choosing an appropriate time for migration or by notifying relevant colleagues about the upcoming server restarts.

Step 1

Perform a Manual Backup (.mdf & .ldf) on Previous / Old Server

✍️ NOTE

 In this scenario, the Automation project name to backup Domino Automation

 

  1. Open Windows services



  2. Search for "SQL Server (INSTANCE_NAME)"



  3. Right-click / "Stop" the service.

          



  4. Right-click, then "Properties" on SQL Server (INSTANCE NAME).



  5. Change the "Startup Type" to "Disabled"



  6. The SQL service is now stopped and disabled on the old server

  7. Open File Explorer



  8. Navigate to the directory

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

  9. Example of path



  10. The directory contains several .mdf and .ldf files



  11. Copy the following 4 files



  12. Paste these files into a backup device or directory



  13. Result:



  14. The database has been manually backed up.

  15. You may shut down the previous (old) server now.

Step 2

Install the Software and Database on the New Server

  1. Download Domino Automation Setup

  2. Extract "designer-designer-xxxx.zip" into the C\temp directory.



  3. Right-click and run the "Automation_setup_XXXX.exe" setup as an administrator.



  4. The following screen appears, click "Next"



  5. Read and accept the License Agreement, click Next



  6. Install MQTT (Mosquitto Broker) if needed



  7. Click on "Install" to automatically install the instance, the database, and the software



  8. Wait while the software and database are being installed





  9. At the end of the setup, the following window is shown



  10. Confirm the end of the setup by clicking on "Finished."

Step 3

Restore the Database through .mdf & .ldf Methodology on New Server

  1. Open Windows explorer



  2. Connect the backup device that includes the .mdf & .ldf files of the database



  3. Copy the 4 .mdf & .ldf files.



  4. Navigate to the "DATA" directory of SQL

    1. C:\Program Files\Microsoft SQL Server\MSSQL16.DASQL\MSSQL\BackupC:\Program Files\Microsoft SQL Server\MSSQL16.DASQL\MSSQL\DATA

  5. Then paste the backups



  6. Result



  7. Install then open SQL management studio



  8. Connect to the instance



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

    1. SERVER_NAME\INSTANCE_NAME
    2. SERVER_IP\INSTANCE_NAME

  10. After connecting, the following page appears



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



  12. Right-click on "Databases" then choose "Attach"



  13. Click on "Add..."



  14. Select the first file "Domino Automation.mdf" and then click "OK"



  15. Click on "Add..." again



  16. Select the second file "Domino Automation_Metrics.mdf" and then click "OK"



  17. Result:



  18. Validate the restoration by clicking "OK"



  19. Your restored database files should now appear in the directory



  20. That means the system has been successfully migrated and restored.

Step 4

Configure Database Owner on New Server

✍️ NOTE

On Domino Automation, if the following message pops up while opening a project

“Owner of database <project_name> must be ‘TeeDbo’ or another local MSSQL login”

The account “TeeDbo” has to be configured as the DBowner & Enable Broker.

 

  1. Open SQL management studio



  2. Connect to your SQL server’s instance



    1. SERVER_NAME\INSTANCE_NAME
    2. SERVER_IP\INSTANCE_NAME

  3. Right-click, then properties on the <project_name>



  4. Navigate to the “Files” menu

       

  5. The database owner is blank, select the triple dots […]



  6. Click on “Browse…”



  7. Select “TeeDbo”



  8. Confirm with “Ok”





  9. Before validating, clic on "Options"



  10. Scroll to the bottom, the "Broker" must be Enabled



  11. Validate through “OK”

    Repeat the same steps for the Metric Database.

  12. Right-click / properties on the <project_name_Metrics>



  13. Navigate to the “Files” menu

       

  14. The database owner is blank, select the triple dots […]



  15. Click on “Browse…”



  16. Select “TeeDbo”



  17. Confirm with “Ok”





  18. Before validating, click on "Options"



  19. Scroll to the bottom, the "Broker" must be Enabled

Step 5

Update Server Name in Automation on New Server

  1. Open Domino Automation



  2. The software will load the available projects, select the right project to open then click on "Existing project"



  3. The software loads the project and show the home page



  4. Open the « Network » menu



  5. Click on « Controller services »



  6. If the database comes from another server or machine, you need to enter your machine's DNS name in the "network address"



  7. This information can be found in "Control Panel / System"



  8. Check the "Full computer name" line