ERROR: Database scripting failed > Script failed for Database 'master'


#1

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


#2

Hi Ruedi_Neff,

Could you please try to install the latest release of SQLBackupAndFTP - version 12.1.3 and check if the issue is resolved?

You can download it at the “Download” https://sqlbackupandftp.com/download page or upgrade your current edition at your “My Account” https://sqlbackupandftp.com/account page at the “Actions” column. Please use the email address you have used to purchase SQLBackupAndFTP to log in. If the password is lost please follow this link to recover it https://sqlbackupandftp.com/RecoverPassword