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
------------------------------
Original Message:
Sent: 06-07-2024 03:10:29 PM
From: Rahim Cetinel
Subject: Resume for SQL Server dSource creation
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
------------------------------