Delphix Products

Tip of the Day: SQL Server Tips

  Thread closed by the administrator. It is viewable, but not accepting new replies.
  • 1.  Tip of the Day: SQL Server Tips

    Posted 05-22-2014 06:00:00 PM
    No replies, thread closed.
    1. When provisioning a VDB you can select a SQL Server instance that has a higher version than the source database, if the source database version is higher than SQL Server 2005. The VDB will be automatically upgraded.

    2. Linking a dSource 
    • If the staging environment uses the Windows 2003 operating system, the largest size of a database that can be linked to the Delphix Engine is 2TB. This is also the largest size that a virtual database (VDB) can grow to.
    • For all other Windows versions, the maximum size for databases and VDBs is 32TB

    In both cases, the maximum size of the database and resulting VDBs is determined by the operating system on the staging target host.

    3. LogSync is disabled by default for SQL Server data sources. For more information about how LogSync functions with SQL Server data sources, see Managing Data Sources: An Overview.



    #sql
    #tip
    #vdb