Tasks for the SQL Server Database Administrator
Delphix Administration / SQL Server Environments and Data Sources / Setting Up and Configuring Delphix for SQL Server / Tasks for the SQL Server Database Administrator


Understanding the Delphix Deployment Model for SQL Server

Delphix deployment for SQL Server requires three distinct types of database servers:

  1. Source database server – A Windows host on which a SQL Server database resides, which will become the source database for a Delphix dSource.
  2. Target database server – A Windows host on which a SQL Server instance resides, to which Delphix will provision one or more virtual databases (VDBs).
  3. Staging Target database server – A Windows host on which a SQL Server instance resides, to which Delphix will provision a database which is always being restored from backups retrieved from the source database. These restored backups make up the Delphix dSource.

The overall flow of data is that backups from the source database are restored to the staging target database. You can then thin-provision those backups as VDBs.

Related Links