Changes for page Datenbankmanagement
Last modified by Sabrina V. on 2026/08/07 11:23
From version 4.1
edited by Sabrina V.
on 2025/01/24 07:12
on 2025/01/24 07:12
Change comment:
There is no comment for this version
To version 8.1
edited by Sabrina V.
on 2026/08/07 11:23
on 2026/08/07 11:23
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -22,7 +22,7 @@ 22 22 The purpose of reducing the size is therefore to free up space in the database. Either the database or the files it contains can be shrunk. 23 23 24 24 {{aagon.warnungsbox}} 25 -It is essential that you make a database backup before you reduce the size of the database or individual files. If you have not yet made a backup, you must do so urgently. You alone are responsible for ensuring that the database can be restored in the event of an error. Read here how to create an [[ACMP backup >>doc:.Vollständiges ACMP Backup durchführen.WebHome]] 25 +It is essential that you make a database backup before you reduce the size of the database or individual files. If you have not yet made a backup, you must do so urgently. You alone are responsible for ensuring that the database can be restored in the event of an error. Read here how to create an [[ACMP backup >>doc:.Vollständiges ACMP Backup durchführen.WebHome]]and how to [[restore>>doc:.Vollständiges ACMP Backup einspielen.WebHome]] it. 26 26 {{/aagon.warnungsbox}} 27 27 28 28 == Shrink database == ... ... @@ -31,7 +31,7 @@ 31 31 When shrinking a database, make sure that applications such as ACMP or others are not accessing the database. If this is not the case, the shrink will not be optimal, will be very slow or will not be performed at all. So make sure that the relevant services do not access the ACMP database. Use the Activity Monitor to check for possible processes and stop them. 32 32 {{/aagon.infobox}} 33 33 34 -The size of a database is reduced by reducing the size of the database files. This applies to the areas of the database files that are completely free (see also [[Defragmenting the Indexes>>doc:||anchor="HInd izesDefragmentierung"]]). If you only want to reduce the size of individual database files, use the [[//Reduce files//>>doc:||anchor="HDatenbankverkleinern"]] option.34 +The size of a database is reduced by reducing the size of the database files. This applies to the areas of the database files that are completely free (see also [[Defragmenting the Indexes>>doc:||anchor="HIndexesDefragmentation"]]). If you only want to reduce the size of individual database files, use the [[//Reduce files//>>doc:||anchor="HReducingthesizeoffiles"]] option. 35 35 36 36 After you have closed all relevant applications, processes and sessions, go to the Microsoft SQL Server Management Studio left-hand navigation and select the database you want to shrink. Right-click to open the context menu and click //Tasks// > //Contract// > //Database//. 37 37 ... ... @@ -61,7 +61,7 @@ 61 61 If you do not want to reduce the size of an entire database directly, but only selected database files and/or groups of files, you can make such changes separately. This can be useful if, for example, you can identify which of your database files are very large and you want to reduce their size. In this case, the size of the database will be reduced by reducing the size of individual files or groups of files. 62 62 63 63 {{aagon.infobox}} 64 -Please note that this procedure does not free up any allocated database space. To do this, you must include all the database files, which can be done using the [[Shrink database>>doc:||anchor="H Datenbankverkleinern"]] option.64 +Please note that this procedure does not free up any allocated database space. To do this, you must include all the database files, which can be done using the [[Shrink database>>doc:||anchor="HShrinkdatabase"]] option. 65 65 {{/aagon.infobox}} 66 66 67 67 In Microsoft SQL Server Management Studio, open the database in which you want to shrink files. Right-click to open the context menu and select //Tasks// > //Shrink// > //Files//.