Restore drops all tables

Application issues
1

I’m trying to run 2 back ups and 2 restores.

  1. Backup structure only [SUCCESS]
  2. Backup data only (with command to ignore some tables with lots of data) [SUCCESS]
  3. Restore structure script [SUCCESS]
  4. Restore data script [FAILURE]

For some reason when the Restore Data Script task runs, all the tables in my destination database gets dropped. I opened the script and there’s nothing inside it that says it should drop, and there are no options in the tool to say “don’t drop tables” so I don’t know what is happening here.

2

Hi Scott_Davies,

Before starting a restore process - SQLBackupAndFTP recreates a database, after which it executes a script.

Sorry, but we can do nothing here, SQLBackupAndFTP guarantees successful restoration if all the advanced settings are set to default.

Thank you and sorry for the inconvenience.