Hi
We’re using SQLBackupAndFTP successfully since a long time (Version 10.0.8.29451) on Windows 8.1. Now I’ve moved a MS-SQL Database to an higher MS-SQL Version on an other new Database (MS-SQL Express). We’ve done this successfully with an productive Database which runs perfect with this version of SQLBackupAndFTP with no problems. So I’ve made a copy of this successfull job and saved it as the “SQLBackupAndFTP-Job for Development” and I’ve changed the Database and the Destination.
On a DB Copy of this productive Database which we’re running for our development we see now the following error messages in the Log File:
ETAILED LOG:
01/24/2019 07:54:50 Creating backup of master to C:\Users\AVM_LO~1\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\kk12rm55 (using scripting)
01/24/2019 07:54:50 Creating master001.sql
01/24/2019 07:54:50 Scripting the database with MS SMO
01/24/2019 07:54:52 Prefetching database objects
01/24/2019 07:54:52 Scripting database creation
01/24/2019 07:54:52 Scripting roles and users
01/24/2019 07:54:52 Scripting database permissions
01/24/2019 07:54:52 ERROR: Database scripting failed > Script failed for Database ‘master’. > Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index
01/24/2019 07:54:52 ERROR: Database scripting failed > Script failed for Database ‘master’. > Der Index lag außerhalb des Bereichs. Er muss nicht negativ und kleiner als die Auflistung sein.
Parametername: index
SqlBackupAndFtp 10.0.8.29451 Standard (started manually) at VS-004 (Microsoft Windows NT 6.2.9200.0) (.NET: 2.0.50727.4927, 3.0.30729.4926, 3.5.30729.4926, 4.6.1055, 4.0.0.0)
Strange is that a manual SQL-Backup-Job trough the MS-SQL Management-Studio is running without complains or error-messages.
Creating a complete new job runs into the same errors.
Do you have any idea how to solve this?
Kind regards