Delphix Products

 View Only
  • 1.  Resume for SQL Server dSource creation

    Posted 8 days ago

    Hi everyone,

    I was wondering if Delphix Engine can resume for a canceled or stopped SQL Server dSource create operation as it is with Oracle databases.

    I assume that it does but I have not experienced it myself.

    Would you please share your insight.

    BR,

    -Rahim



    ------------------------------
    Rahim Cetinel
    Lead Dataops Architect | Delphix Blackbelt
    ------------------------------


  • 2.  RE: Resume for SQL Server dSource creation
    Best Answer

    Posted 8 days ago

    Hi Rahim,

    Delphix doesn't support this with SQL Server most likely because SQL Server itself doesn't support it. I found that there is a RESTORE "WITH RESTART" clause and have raised a new feature request to investigate whether or not using it would be beneficial (IDEA-3671).

    It isn't clear to me if using that clause would be super beneficial as Microsoft's documentation ( https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restart-an-interrupted-restore-operation-transact-sql?view=sql-server-ver16 ) mentions:

    restarts the restore process. There's no resume option for an interrupted restore operation.

    However, RESTART saves some time by skipping the analysis phase of database recovery, and in most cases, RESTART doesn't need to recreate the database files, which can save a significant amount of time for larger databases, especially if Instant File Initialization (IFI) isn't enabled.

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------