Add DSource DB fails because there are multiple lite speed backup copies

  • 0
  • 1
  • Problem
  • Updated 2 years ago
  • Solved
Something interesting:  I am able to ingest SQL Server lite speed backup files without any issues as long as there is only one backup copy in the backup folder.  Has anyone experienced this type of issue and how do I get around it without removing duplicate copies.

The backups are located in different sub folders but within the major Backup folder.

IE:  \backup\db folder1\db1.bak
       \backup\db folder2\db1.bak

Here is a typical error message:  What if I remove access to "ServerMove" folder.

Sep 26, 2017 10:00 PM

Title: Source database backup location has multiple files with the same name
Details: Found multiple backup files for source database "DBA" with the same name "VDC1DBOLTP04_DBA.BKP" in the shared backup location "\\va10pwpsql315v1\G$\SQL01\SQLBackup" at paths: \\va10pwpsql315v1\G$\SQL01\SQLBackup\Backup\VDC1DBOLTP04_DBA.BKP, \\va10pwpsql315v1\G$\SQL01\SQLBackup\ServerMove\VDC1DBOLTP04_DBA.BKP
User Action: Make sure that the backup location for the source database is correct and that the backup file names are unique.
Photo of Arun Modasra

Arun Modasra

  • 100 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,602 Points 3k badge 2x thumb
Official Response
Hi Arun,

Delphix is designed to recursively search through the designated backup path. See our KB article for more information about this and the "Autodiscover" feature for the backup path. It monitors some tables in the SQL Server instance and when it sees that the file "db1.bak" has been created, it goes out and looks for that file.

Delphix examines every file that it finds matching the file name to see if it belongs to that backup set. If there are multiple files found belonging to the same backup set, Delphix presents this alert because it does not know which one to restore into the staging database.

So it sounds like you have manually defined the backup path to "\\va10pwpsql315v1\G$\SQL01\SQLBackup". If you were to edit the dSource and change the backup location to ""\\va10pwpsql315v1\G$\SQL01\SQLBackup\Backup", Delphix would find only the one file.