Delphix creates a staging database using user provided source backup from a backup staging directory. 

In order to ensure that the staging database remains in-sync with the source database, User can provide additional differential backups from the source database to the staging database. 

Prerequisites 

  • Staging environment must be added to Delphix. 

  • A Source Config must be created on the staging environment-MSSQL Linux repository. 

  • A MSSQL Linux with the same version as the source database must be installed in the Staging environment. 

It may take up to 5 minutes after successful dSource creation for the status to show as Active. 

Creating dSource  

  1. Login to Delphix Management application. 

  2. Click Manage > Datasets. 

  3. Select Add dSource.
    MS SQL Linux link data sources

  4. In the Add dSource wizard, select the MSSQL source configuration which is created on the staging host.
    MS SQL Linux link data sources

  5. Provide all required details for dsource creation 

    1. MSSQL user

    2. MSSQL Staging user with sysadmin role. 

    3. MSSQL user password

    4. Password of the provided user. 

    5. Backup file location

    6. Path to backup files used to update the dsource located on staging host. 

    7. Backup filename pattern

    8. Pattern used to identify backup files (eg. *.bak). 

    9. Staging Database Mount Path (on Staging Host)
      This is the mount directory for Delphix on the staging host. This location should be unique and empty. 

    10. Upgrade: Use this option if the source database is an older but compatible version. 

  6. On dSource Configuration screen, select the dataset group where the dSource will be placed and click Next. 

  7. On the Data Management screen, select the staging environment and the environment user and click Next. 

The combination of both parameters Backup file location and Backup filename pattern, should list only the necessary backup file(s) to be used for the SnapSync operation.  Ensure Resynchronize dsource option is marked. 

  1. On the Policies screen, select the Snapsync and Retention policies for the dSource and click Next. 

  2. On the Hooks screen, add any pre-sync and (or) post-sync hooks as required and click Next. 

  3. Review the dSource configuration on the Summary screen and submit. The Linking process begins. 

Once the dSource creation is successful, the Timeflow tab should show the initial snapshot.


Last updated
Oct 9, 2026