delphix needs access to sqlserver backup taken by NETBACKUP

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Trying to set up Delphix for sqlserver Dsource created successfully , now in order to keep it in sync Delphix needs access to backup location but our db backups are taken by NETBACKUP ... how to link this so Dsource can remain in sync??
Photo of Anjana

Anjana

  • 70 Points

Posted 4 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Official Response
Anjana,
Backup images of the source database (full, differential, and/or transaction logs) must be available over an SMB share to a staging environment. Can you create a MSSQL job to create these and place them on a SMB share somewhere in your environment? You can set the retention level to a short duration as they no longer have to reside on the system once Delphix has read them. 

More info on these requirements can be found here: http://docs.delphix.com/display/DOCS40/Setting+Up+SQL+Server+Environments%3A+An+Overview

Additionally,
Supported SQL Server Backup Software

Delphix interacts with source database backups in the following ways:

  1. When linking a new source database into Delphix: Here Delphix can use an existing full backup to load the source database data.
  2. When performing a sync of an existing dSource: Here again Delphix can use an existing full backup.
  3. After the dSource is created, Delphix picks up any new transaction log backups that are taken on the source database and applies them to the copy of the source database on Delphix. 

Delphix currently supports the following backup software for source database backups:

  1. SQL Server native backups.
  2. Quest/NetVault LiteSpeed: If the source database is backed up with LiteSpeed, the source and the staging environments must have the same version of LiteSpeed installed on them. Delphix currently supports LiteSpeed v5.0.0.0 and onwards.
(Edited)