Delphix Products

 View Only
  • 1.  re-link SQL server dSource

    Posted 05-20-2019 07:47:00 PM
    When I try to re-lonk a SQL server dSource using legit parameters, I am getting this error message: 
    Error Sync must load from existing full or differential database backups because the source database "RetailPOR" is in simple recovery model.
    Error Code exception.db.mssqlldb.sourcedb.simple_mode.backup_load.invalid
    Suggested Action Sync using an existing full or differential database backup.


  • 2.  RE: re-link SQL server dSource
    Best Answer

    Posted 05-20-2019 08:41:00 PM
    Hello,

    What that error message is trying to suggest is that the source database is in "simple" recovery mode which means that it cannot produce transaction logs ( https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server?view=sql-server-2017 ).

    So if you want Delphix to stay synchronized with it, you would want to either:
    • Change the source database's recovery model to full or bulk logged
    • Then change the Delphix dSource's validatedSync mode to transaction logs
    or:
    • Select a validatedSync mode that is appropriate for a database that is configured to be in the "simple" mode (FULL or DIFFERENTIAL).