[Files] Source: Source: "C:\projects\Atechnology.installer.v3\Database_backup\dealer.bak"; DestDir: "{tmp}"; Flags: ignoreversion recursesubdirs createallsubdirs; Components: srv Source: "C:\projects\Atechnology.installer.v3\Database_backup\dealer.bak"; DestDir: "{app}\Base\"; Flags: ignoreversion recursesubdirs createallsubdirs; Components: srv [Run] Filename: "{pf64}\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\sqlcmd.exe"; Description: "Развертывание базы ABC"; Parameters: "-U sa -P 123123 -S localhost -d master -Q ""RESTORE DATABASE dealer FROM DISK='{app}\Base\dealer.bak' WITH MOVE 'ecad' TO '{app}/Base/dealer.mdf', MOVE 'ecad_log' TO '{app}/Base/dealer_log.ldf', REPLACE; exec sp_configure 'clr enabled',1; RECONFIGURE WITH OVERRIDE;"" "; StatusMsg: "Развертывание базы ABC..."; Components: srv

I want to understand why the database is not deployed from the backup, SQL 2016 is installed correctly, checked. Thank you in advance for your help

enter image description here

  • Below is a picture, when restoring the database, some links to the files on them errors occur - Roman Ieromenko

1 answer 1

In the [Run] section instead of localhost you need to write the full name of the SQL server, the database was created