To provision a virtual database using Point-in-time, you will need a linked dSource from a source host with Validated Sync mode as Transaction Log and logsync enabled and a compatible target environment, as described in the Requirements for SQL Server environments and SQL Server Matrix.
To perform a point-in-time (PIT) VDB provision in DCT:
-
Log in to DCT.
-
Navigate to Data > Data Management > VDB and click Provision VDB. For more information, refer to Provisioning a SQL Server VDB.
-
Select a SQL Server dsource with logsync enabled under the dSources tab to provision and click Next.
-
On the Provision Point page, select:
Select Exact Time (Slower): Choose the exact date and time using the calendar.
-
Select the target environment and repository.
-
On the Target Configuration page, choose the database recovery model and database name. Optionally, configure VDB parameters and other advanced settings and click Next.
-
On the Policies page, select the default DCT Snapshot and DCT Retention policies and click Next.
-
(Optional) On the Masking page, select Mask this VDB.
-
(Optional) On the Hooks page, configure provisioning hooks and click Next. For more information, refer to Hook operations list and SQL Server hook operations.
-
Review the VDB summary details and click Submit.