Importing a full ACMP backup

Last modified by Sabrina V. on 2024/10/08 11:35

Initial situation

If an ACMP update fails for various reasons, the previously created backup should be restored. To do this, first overwrite the ACMP SQL Server files with the backup files and then import the ACMP database backup into Microsoft SQL Management Studio.

Importing the backed up ACMP Server data

1. Copy the backed up ACMP Server directory back to the original location, e.g. C:\Program Files (x86)\Aagon\ACMP Server, and overwrite the data.
2. If you have outsourced file repositories, copy them back to the correct location as well.

Restore the database

1. Go to Microsoft SQL Management Studio.
2. From the databases, select the ACMP database, in this case ACMP. Select it and right click on Delete. This will remove the corrupt database.

66_Datenbank Backup einspielen_371.png

Delete database

3. A new window will open allowing you to select the item to be deleted. Leave all the settings as they are and click OK.
4. Navigate back to the databases folder and right click on Restore database.

66_Datenbank wiederherstellen_413.png

Restore database

5. A new window will open where you can upload the .bak file. To do this, select Media under Source and click on the icon to the right of it (image-20240314150648-1.png).
6. You should now select the backup medium. Go to Add and select the database backup. In this case the file is called ACMP.bak.
7. Click OK.
8. Leave the rest of the settings as they are and click OK again to restore the entire database.

66_Datenbank wiederherstellen ACMP_797.png

Restore database

You will receive a message that the database has been successfully restored and you can already find it under databases in SQL Management Studio.

Hinweis  Note:  

It is a good idea to check the recovery model of the database at the end of the import. To do this, right-click on the ACMP database and navigate to Properties > Options > Recovery Model. The model should be set to Simple. Change this if necessary.

66_Datenbankeigenschaften_698.png

Restore database

Hinweis  Note:  

Be sure to restart the server service before logging in to the console! If you do not, you will not be able to connect to the server.

© Aagon GmbH 2024
Besuchen Sie unsere neue Aagon-Community