Wiki source code of Vollständiges ACMP Backup einspielen
Last modified by Jannis Klein on 2024/08/13 08:28
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{aagon.priorisierung}} | ||
| 2 | 160 | ||
| 3 | {{/aagon.priorisierung}} | ||
| 4 | |||
| 5 | {{aagon.floatingbox/}} | ||
| 6 | |||
| 7 | = Initial situation = | ||
| 8 | |||
| 9 | 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. | ||
| 10 | |||
| 11 | == **Importing the backed up ACMP Server data** == | ||
| 12 | |||
| 13 | ~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. | ||
| 14 | 2. If you have outsourced file repositories, copy them back to the correct location as well. | ||
| 15 | |||
| 16 | == **Restore the database** == | ||
| 17 | |||
| 18 | ~1. Go to Microsoft SQL Management Studio. | ||
| 19 | 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. | ||
| 20 | |||
| 21 | {{figure}} | ||
| 22 | (% style="text-align:center" %) | ||
| 23 | [[image:66_Datenbank Backup einspielen_371.png]] | ||
| 24 | |||
| 25 | {{figureCaption}} | ||
| 26 | Delete database | ||
| 27 | {{/figureCaption}} | ||
| 28 | {{/figure}} | ||
| 29 | |||
| 30 | 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//. | ||
| 31 | 4. Navigate back to the databases folder and right click on //Restore database//. | ||
| 32 | |||
| 33 | {{figure}} | ||
| 34 | (% style="text-align:center" %) | ||
| 35 | [[image:66_Datenbank wiederherstellen_413.png]] | ||
| 36 | |||
| 37 | {{figureCaption}} | ||
| 38 | Restore database | ||
| 39 | {{/figureCaption}} | ||
| 40 | {{/figure}} | ||
| 41 | |||
| 42 | 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:image-20240314150648-1.png||height="20" width="20"]]). | ||
| 43 | 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. | ||
| 44 | 7. Click //OK//. | ||
| 45 | 8. Leave the rest of the settings as they are and click //OK// again to restore the entire database. | ||
| 46 | |||
| 47 | {{figure}} | ||
| 48 | (% style="text-align:center" %) | ||
| 49 | [[image:66_Datenbank wiederherstellen ACMP_797.png]] | ||
| 50 | |||
| 51 | {{figureCaption}} | ||
| 52 | Restore database | ||
| 53 | {{/figureCaption}} | ||
| 54 | {{/figure}} | ||
| 55 | |||
| 56 | You will receive a message that the database has been successfully restored and you can already find it under databases in SQL Management Studio. | ||
| 57 | |||
| 58 | {{aagon.infobox}} | ||
| 59 | 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. | ||
| 60 | |||
| 61 | {{figure}} | ||
| 62 | (% style="text-align:center" %) | ||
| 63 | [[image:66_Datenbankeigenschaften_698.png]] | ||
| 64 | |||
| 65 | {{figureCaption}} | ||
| 66 | Restore database | ||
| 67 | {{/figureCaption}} | ||
| 68 | {{/figure}} | ||
| 69 | {{/aagon.infobox}} | ||
| 70 | |||
| 71 | {{aagon.infobox}} | ||
| 72 | 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. | ||
| 73 | {{/aagon.infobox}} |