Understanding Database Users and Privileges for SQL Server Instances

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