This topic describes how to provision a virtual database (VDB) from a SQL Server dSource.

Prerequisites

Procedure

  1. Login to the Delphix Admin application.
  2. Click Manage.
  3. Select My Datasets.
  4. Select a dSource.
  5. Select a means of provisioning.
    For more information, see Provisioning by Snapshot and LogSync.
  6. Click Provision.
    The Provision VDB panel will open, and the Database Name and Recovery Model will auto-populate with information from the dSource.
  7. Select a target environment from the left pane.
  8. Select an Instance to use.
  9. If the selected target environment is a Windows Failover Cluster environment, select a drive letter from Available Drives. This drive will contain volume mount points to Delphix storage.

    Windows Cluster Volume Management Software Requirements

    Only cluster volumes managed by the native Windows Volume Manager are supported. For example, cluster volumes managed by Veritas VxVM are not supported.

    If you use third-party volume management software, create a new LU (recommended to be 10GB in size) and add this LU as a clustered resource to the SQL Server instance using native Windows volume management tools. Assign a drive letter for this LU. You can then use this LU as the volume mount point location for Delphix VDB provisioning.

  10. Specify any Pre- or Post-Scripts that should be used during the provisioning process.
    For more information, see Customizing SQL Server VDB Management with Hook Operations.
  11. Click Next.
  12. Select a Target Group for the VDB.
    If necessary, click the green Plus icon to add a new group.
  13. Select a Snapshot Policy for the VDB.
    If necessary, click the green Plus icon to create a new policy.
  14. Click Next.
  15. Enable Auto VDB Restart to allow the Delphix Engine to automatically restart the VDB when it detects target host reboot.
  16. If your Delphix Engine system administrator has configured the Delphix Engine to communicate with an SMTP server, you will be able to specify one or more people to notify when the provisioning is done. You can choose other Delphix Engine users, or enter email addresses.
  17. Click Finish.

When provisioning starts, the VDB will appear in the Datasets panel. Select the VDB and navigate to the Status tab to see the progress of the job. When provisioning is complete, you can see more information on the Configuration tab.

You can select a SQL Server instance that has a higher version than the source database and the VDB will be automatically upgraded. For more information about compatibility between different versions of SQL Server, see SQL Server Operating System Compatibility Matrices.

Provisioning by Snapshot or LogSync

When provisioning by snapshot, you can provision to the start of any particular snapshot, either by time or LSN.

You can take a new snapshot of the dSource and provision from it by clicking the Camera icon on the Configuration tab.

Provisioning By SnapshotDescription
Provision by TimeYou can provision to the start of any snapshot by selecting that snapshot card from the TimeFlow tab, or by entering a value in the time entry fields below the snapshot cards. The values you enter will snap to the beginning of the nearest snapshot.
Provision by LSNYou can use the Slide to Provision by LSN control to open the LSN entry field. Here, you can type or paste in the LSN to which you want to provision. After entering a value, it will "snap" to the start of the closest appropriate snapshot.

Automatic VDB Restart on Target Server After Reboot

The Delphix Engine now automatically detects whether a target server has been rebooted, and proactively restarts any VBD on that server that was previously up and running. This is independent of data platform. It is done as if you realized a target server was restarted and issued a start command from the Delphix Engine. This feature is compatible with Jet Stream ordering dependencies and is limited to non-clustered VDBs.
Note: It does not work for Oracle RAC VDBs, Oracle 12c PDB/CDB or MSSQL cluster VDBs.

To enable automatic restart, complete the following steps:

  1. When provisioning a new VDB in the VDB Provisioning wizard, check the Auto VDB Restart box. 
    autorestart 1.png
  2. Under the Summary tab you can verify that this feature is enabled. 
    autorestart 2.png
  3. Once the VDB has been provisioned, you will be able to turn Automatic VDB Restart on.
  1. In the Datasets panel, select the VDB.

  2. Select the Configuration tab.

  3. Select the Standard sub-tab.

autorestart 3.png

Related Links