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

Prerequisites

Procedure

  1. Log into the Delphix Admin application.
  2. Select Manage > Databases > My Databases.
  3. Select a dSource.
  4. Select a means of provisioning.
    See Provisioning by Snapshot and LogSync in this topic for more information.
  5. Click Provision.
    The Provision VDB panel will open, and the Database Name and Recovery Model will auto-populate with information from the dSource.
  6. Select a target environment from the left pane.
  7. Select an Instance to use.
  8. 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.
  9. Specify any Pre or Post Scripts that should be used during the provisioning process.
    See Using Pre- and Post-Scripts with dSources and SQL Server VDBs for more information.
  10. Click Next.
  11. Select a Target Group for the VDB.
    Click the green Plus icon to add a new group, if necessary.
  12. Select a Snapshot Policy for the VDB.
    Click the green Plus icon to create a new policy, if necessary.
  13. Click Next.
  14. 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 .
  15. Click Finish.
    When provisioning starts, you can review progress of the job in the Databases panel, or in the Job History panel of the Dashboard. When provisioning is complete, the VDB will be included in the group you designated, and listed in the Databases panel. If you select the VDB in the Databases panel and click the Open icon, you can view its card, which contains information about the database and its Data Management settings.

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

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 dSource card.

Provisioning By SnapshotDescription
Provision by TimeYou can provision to the start of any snapshot by selecting that snapshot card from the TimeFlow view, 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 you want to provision to. After entering a value, it will "snap" to the start of the closest appropriate snapshot.


If LogSync is enabled on the dSource, you can provision by LogSync information. When provisioning by LogSync information, you can provision to any point in time, or to any LSN, within a particular snapshot. The TimeFlow view for a dSource shows multiple snapshots by default. To view the LogSync data for an individual snapshot, use the Slide to Open LogSync control at the top of an individual snapshot card.

Provisioning By LogSyncDescription
Provision by TimeUse the Slide to Open LogSync control to view the time range within that snapshot. Drag the red triangle to the point in time that you want to provision from. You can also enter a date and time directly.
Provision by LSNUse the Slide to Open LogSync and Slide to Provision by LSN controls to view the range of  LSNs within that snapshot. You must type or paste in the specific LSN you want to provision to. Note that if the LSN doesn't exist, you will see an error when you provision.

Related Links