Delphix Products

Expand all | Collapse all

Basic mssql flow

Jump to Best Answer
  • 1.  Basic mssql flow

    Posted 02-08-2015 10:56:00 PM
    Hi I have been reading a lot of the documentation, but need to know if I understand it right :) The mssql staging database instance is picking up transactions backups and applying them to the staging database and then makes a Delphix file system consistent snapshot. So when I provision the vdb/snapshot to a target machine it will mount that snapshot and start the mssql. But how does it work provisioning vdbs in specific minutes or even seconds? - is it done when provisioning by applying additional transactions after the "nearest" file system snapshot? Also when provisioning, there has to be a running target for each vdb? Or can one "target" host multiple mssql instances? Thanks


  • 2.  RE: Basic mssql flow
    Best Answer

    Posted 02-09-2015 08:44:00 PM
    Hi Felix,
    When a VDB is created from a snapshot a separate files system is created specifically for that VDB and that is mounted on the target server. We then create the specified database in the SQL Server instance, which has to be started and accessible to us and is specified during provisioning.

    You can specify a point in time when provisioning a VDB only if you have enabled logsync on the dsource first.

    A target or source server can have many SQL Server instance on it. We ask that the customer manage the memory such that it is not over allocated between the SQL Server instances and other process running on that host.
    A target server can also have many VDBs provisioned to it's one or many SQL Server instances.

    I hope this helps.
    Cheers,
    Dave G.


  • 3.  RE: Basic mssql flow

    Posted 02-09-2015 08:52:00 PM
    Oki so I could have multiple VDBs assigned to one target with one MSSQL instance? - so databases will be named differently?

    logsync is that the mssql transaction backups? - and is there a Delphix filesystem snapshot for each transaction backup restore on staging server or is there some logic for running the transactions when provisioning?

    Thanks again


  • 4.  RE: Basic mssql flow
    Best Answer

    Posted 02-10-2015 06:32:00 PM
    Hi Felix,

    Yes, if multiple VDBs are assigned to the same SQL Server instance on a target, they would have to be named uniquely.

    LogSync works exactly as you suggest.
    Delphix keeps track of the transaction log backups as they happen on the production source and takes a snapshot after restoring each one on the staging server. If LogSync is enabled, the transaction logs are preserved. When provisioning, we pick the closest snapshot to the point in time that you pick, and then apply the transaction log (using the "stop at" clause).

    Hope this answers your questions.

    -Ankur