Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only

  • 1.  Snapsynch creation using dxtoolkit for mssql db

    Posted 08-27-2022 02:29:00 AM
    Hi Delphix,

    I have a scenario where we need to ingest data from a MSSQL db which is in simple recovery mode. I created the dsource however while running a snapsynch on this dsource it failed with error message "synch load should be full or differential because the source is in simple recovery mode" can you please suggest a way around. We used delphix managed backups while ingesting the data. Thanks.

    Regards,
    Nitin

    ------------------------------
    Nitin Gupta
    Environment Manager
    Delphix Community Members
    ------------------------------


  • 2.  RE: Snapsynch creation using dxtoolkit for mssql db

    Posted 08-27-2022 04:03:00 AM
    Edited by Adam Smith 08-27-2022 04:04:20 AM
    Hi Nitin,

    Thank you for contacting the Delphix Community.

    When you selected the Initial Load option, which option did you choose?

    If you selected the "Delphix will take a copy-only full backup of your source database" option, then simple recovery is not supported.

    Please see: Linking a dSource from a SQL Server: An Overview

    Simple Recovery Model:
    If the source database is using a simple recovery model, using a new full COPY_ONLY backup initiated by the Delphix Engine is not supported for the initial load of a dSource.

    With Simple Recovery, you also won't be able to ingest transaction logs.

    Please let us know if this helps.

    If you continue to have issues, please log a support ticket.

    Thank you

    ------------------------------
    Adam Smith
    Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: Snapsynch creation using dxtoolkit for mssql db

    Posted 08-27-2022 07:02:00 AM
    Hi Adam,
    Thanks for the response!
    We are using Delphix managed option for the data ingestion from the source DB. If we need to ingest the data as full or differential from the source db(not from a backup file) then what option we should be using with dxtoolkit command.

    Regards,
    Nitin

    ------------------------------
    Nitin Gupta
    Environment Manager
    Delphix Community Members
    ------------------------------

    Original Message


  • 4.  RE: Snapsynch creation using dxtoolkit for mssql db

    Posted 08-27-2022 12:46:00 PM
    Hello Nitin-

    It is generally helpful to provide exact command syntax and output for diagnosing dxtoolkit command usage, etc.  However, in a quick test, I've created a SQL Server dSource in SIMPLE recovery mode, and linked with Delphix Managed backups, as you mentioned:

    " We used delphix managed backups while ingesting the data."

    This implies that the original SnapSync was successful, but please correct me if otherwise.

    Once my own dSource is established, with Delphix Managed Backups working, I can issue a dx_snapshot_db command which will use the existing configuration, and no issues are encountered.  So if you can elaborate on the details of the configuration, the exact command used, and the output of the command, that may help.  In this configuration, no additional options need to be specified, only the Engine identifier and dSource name.

    We do also generally recommend retrying with the latest dxToolkit, if it is not already installed, in case there's a behavioral issue resolved in a more recent version.

    ~/work/dxtoolkit/dxtoolkit2$ ./dx_snapshot_db -d sean6015 -name SQL
    Starting job JOB-70 for database SQL.
    0 - 5 - 11 - 12 - 15 - 55 - 56 - 96 - 100
    Job JOB-70 finished with state: COMPLETED








    ------------------------------
    Sean Nothdurft
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


  • 5.  RE: Snapsynch creation using dxtoolkit for mssql db

    Posted 08-27-2022 09:08:00 PM
    HI Sean,

    I am using the below commands to create dsource and take a snapshot. Thanks

    dx_ctl_dsource -d <engineName> -type MSSQL -sourcename  <DBName> -sourceinst <instanceName> -sourceenv <envName> -dbusertype domain -dbuser <user> -password <pwd> -group <groupname> -creategroup -dsourcename <dsourcename> -stage_os_user <user> -stageinst <instanceName> -stageenv <envName> -action create


    dx_snapshot_db -d <engineName>  -name <dscource Name>


    Regards,
    Nitin





    ------------------------------
    Nitin Gupta
    Environment Manager
    Delphix Community Members
    ------------------------------

    Original Message


  • 6.  RE: Snapsynch creation using dxtoolkit for mssql db
    Best Answer

    Posted 08-29-2022 03:05:00 AM
    Hi Nitin,

    You need to add flag "-delphixmanaged yes" to your dx_ctl_dsource command so dxtoolkit will create a Delphix managed dSource.
    Without a flag dxtoolkit is creating a "normal" dSource which is expecting backup files.

    regards,
    Marcin

    ------------------------------
    Marcin Przepiorowski
    Director, Technical Services
    Delphix
    ------------------------------

    Original Message


Related Content