Delphix Products

Expand all | Collapse all

Diffirential/Incrementel Snapshot for SQL server problem

Jump to Best Answer
  • 1.  Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-05-2016 09:39:00 PM
    Hi This is Delphix demo butt is not landshark. I am now trying to do POC and ; Maybe I am missing something maybe there is bug on my systems. Here is What I did I added my environments source,validated sync, target1 and target2 I run discover and after that I added dsource for each database, recovered from source environment by engine While adding this dsource I select backup location autodiscover, transaction log and logsync enabled, for other backup options on the dsource menu I did not select any ( full backup, full backup or differential backup, none ) So When I click next next and finish. Snapshot is started but It gave me an error ( I think it is trying to backup up transaction logs but there is no full backup yet so it should be normal ) I went on to start snapshot for the first time " Delpix will take a copy-only backup of your source database" .... Until here everything is ok because there is no full backup and I think I can not add dsource for the first time with "transaction logs" so I did full backup for the first snapshot but After this first snapshot is completed I should be able to start snapshot again with the option " Use the most recent full or differential backup " ? But I am getting warning " Delphix Engine has already applied the database backup with UUID "748E11...." so I can't take encrymentel/differential or whatever it is for my source SQL database I can't find any clear documents on docs.delpix.com so If I am enough clear to explain my case Please help me or tell me if you need any extra information. By the way please consider this source environment is a Test environment which is for POC ( Recovery Mode : Full )
    #DemoEnvironment


  • 2.  RE: Diffirential/Incrementel Snapshot for SQL server problem
    Best Answer

    Posted 10-05-2016 09:52:00 PM
    If you tell Delphix to create a snapshot from the most recent backup, and Delphix already has used that backup for that dSource or has created a more recent backup via copy-only backup, you will get the "Delphix Engine has already applied the database backup with UUID ...." message as Delphix will not load it twice. If you want to take a new snapshot in the manner you describe, then create a new backup of the source database. Delphix will be able to ingest that.


  • 3.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-06-2016 04:56:00 AM
    Hi ADam Thank you for quick response. but please tell me more details What you meant create a new backup of the source database , you want me to do it with a software which is compatible with delphix ? My second question, if I take snapshot with option 1 in the screenshot below, It will be full backup, for the second time with same option it is going to be full backup again ? My third question is more important.. I think even transaction logs is configured for the dsource and sync is enabled, transaction log is not triggering by engine or .. and I cant see snapshot card for these transaction logs on the screen I didnt understand this part how it work? Thank you in advance again


  • 4.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-06-2016 05:44:00 AM
    Delphix will automatically detect new backups, if they are placed in a directory available to the staging server. If you have full/differential/log shipping setup as a scheduled service on the MSSQL source, Delphix can automatically ingest those, if you have log sync turned on.

    Have a look here:
    https://docs.delphix.com/display/DOCS50/Setting+Up+SQL+Server+Environments%3A+An+Overview
    and here:
    https://docs.delphix.com/display/DOCS50/Linking+a+SQL+Server+dSource

    Instead of using autodiscovery, you may need to specify the UNC path for target to the backup directory on the source, ie \\WINDOWSSOURCE\BACKUPS


  • 5.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-06-2016 06:57:00 AM
    Last sentence make me a little bit confused,

    Please give me sample according to my inventory. Which environment should be staging because When I use backup select query I see the backup path is Validated-sync server ( ST-DELPHIX-SYNC ) 

    Is this correct or Should patch be \\st-delphixsrc\....  ?




    here is my environments

    ST-DELPHIXSRC
    ST-DELPHIX-SYNC
    ST-DELPHIXTARTGET1 


  • 6.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-06-2016 09:00:00 PM
    Hi Adam Thank your for your reply.. I totaly misundertood the structure before talking to you and Wylde. Actually Wylde helped me so much to understand how this is working during our webex session and now I understand your explanation more clearly :) Thanks again


  • 7.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-06-2016 09:25:00 PM
    Fantastic. Wylde is an amazing guy. Glad he got you sorted!


  • 8.  RE: Diffirential/Incrementel Snapshot for SQL server problem

    Posted 10-07-2016 07:13:00 AM
    I see :) he is really good