MS SQL® Project Backup
- The recommended tool for the MS SQL® Project Backup is the "SQL Server Management Studio 19". You can download it here https://aka.ms/ssmsfullsetup.
- The standard DBMS object name is winccoa and it is created with the standard user sa. That is the target to backup and restore.
-
Use the SQL Server Management Studio:
With this tool you can create a full backup of you DBMS object according the very detailed MS description: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver16
-
To restore an MS SQL Server:
*.bak DBMS object: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-ver16.
- Alternatively, you can use the backup /restore script which is provided in the /data/NGA/MSSQLServer/sql/ directory
backupMSSQLServer.cmd /
restoreMSSQLServer.cmd
You have to enter the command line parameters according the WinCC OA help MS SQL® Server Installation - DB Parameters.
