Changes for page Datenbankmanagement

Last modified by Sabrina V. on 2025/03/31 09:30
From version 1.1
edited by Jannis Klein
on 2024/08/13 08:28
Change comment: Imported from XAR
To version 5.1
edited by Sabrina V.
on 2025/03/31 09:30
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.jklein
1 +XWiki.SV
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]] and how to [[restore>>doc:.Vollständiges ACMP Backup einspielen.WebHome]] it.
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 ==
... ... @@ -36,8 +36,7 @@
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  
38 38  {{figure}}
39 -(% style="text-align:center" %)
40 -[[image:66_Datenbank_Datenbank verkleinern_690.png]]
39 +[[image:66_Datenbank_Datenbank verkleinern_690.png||data-xwiki-image-style-alignment="center"]]
41 41  
42 42  {{figureCaption}}
43 43  Shrink database
... ... @@ -62,14 +62,13 @@
62 62  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.
63 63  
64 64  {{aagon.infobox}}
65 -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="HDatenbankverkleinern"]] 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="HDatenbankverkleinern"]] option.
66 66  {{/aagon.infobox}}
67 67  
68 68  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//.
69 69  
70 70  {{figure}}
71 -(% style="text-align:center" %)
72 -[[image:66_Datenbank_Datei verkleinern_690.png]]
70 +[[image:66_Datenbank_Datei verkleinern_690.png||data-xwiki-image-style-alignment="center"]]
73 73  
74 74  {{figureCaption}}
75 75  Reducing the size of files
... ... @@ -119,8 +119,7 @@
119 119  Executions Right click on the ACMP Database and select //New Query// from the context menu that opens.
120 120  
121 121  {{figure}}
122 -(% style="text-align:center" %)
123 -[[image:66_Datenbank_Aufruf einer neuen Abfrage_478.png]]
120 +[[image:66_Datenbank_Aufruf einer neuen Abfrage_478.png||data-xwiki-image-style-alignment="center"]]
124 124  
125 125  {{figureCaption}}
126 126  Insert new query
... ... @@ -135,8 +135,7 @@
135 135  ##EXEC ap_index_defrag 0,0##
136 136  
137 137  {{figure}}
138 -(% style="text-align:center" %)
139 -[[image:66_Datenbank_Ausführung einer neuen Abfrage_837.png]]
135 +[[image:66_Datenbank_Ausführung einer neuen Abfrage_837.png||data-xwiki-image-style-alignment="center"]]
140 140  
141 141  {{figureCaption}}
142 142  Execute query SQL script in query
... ... @@ -169,7 +169,7 @@
169 169  
170 170  If you have not set any or incomplete settings for the log files, you can change these in the properties of the ACMP Database. To do this, first exit the ACMP server service.
171 171  
172 -Then open the Microsoft SQL Server Management Studio, log in using the login information and then select the ACMP Database in the navigation on the left. Execute a right-click on the ACMP Database and click on Properties in the context menu that opens. The database properties for the database open. Select the Options menu item. In the second position in the view is the entry Recovery Model. The [[Recovery Model>>https://learn.microsoft.com/de-de/previous-versions/sql/sql-server-2008-r2/ms189275(v=sql.105)?redirectedfrom=MSDN) ]] is an option with which you can define how a los is handled:
168 +Then open the Microsoft SQL Server Management Studio, log in using the login information and then select the ACMP Database in the navigation on the left. Execute a right-click on the ACMP Database and click on Properties in the context menu that opens. The database properties for the database open. Select the Options menu item. The first column in the view is the sort order. Select the //Latin1_General_CI_AS// collation that we recommend (see also the graphic below). This collation is used for both Unicode and non-Unicode. In the second position//, //define a //Recovery Model//. The [[Recovery Model>>https://learn.microsoft.com/de-de/previous-versions/sql/sql-server-2008-r2/ms189275(v=sql.105)?redirectedfrom=MSDN) ]] is an option with which you can define how a los is handled:
173 173  
174 174  |(% style="width:136px" %)**Recovery Model**|**Explanation**
175 175  |(% style="width:136px" %)Full|All database changes are logged. There are no time or size restrictions. Storage and backup requirements are significantly increased.
... ... @@ -179,8 +179,7 @@
179 179  If "Full" or "Bulk logged" is set in the drop-down field, change the entry to "Simple".
180 180  
181 181  {{figure}}
182 -(% style="text-align:center" %)
183 -[[image:66_Datenbank_Datenbankeigenschaften_698.png]]
178 +[[image:66_Datenbank_Datenbankeigenschaften_698.png||data-xwiki-image-style-alignment="center"]]
184 184  
185 185  {{figureCaption}}
186 186  Customize recovery model
... ... @@ -189,4 +189,4 @@
189 189  
190 190  Then click //OK// and the window will close.
191 191  
192 -Then reduce the size of your database. To do this, follow the steps in the section [[Shrinking the database>>https://learn.microsoft.com/de-de/previous-versions/sql/sql-server-2008-r2/ms189275(v=sql.105)?redirectedfrom=MSDN) ||anchor="HDatenbankverkleinern"]]. 
187 +Then reduce the size of your database. To do this, follow the steps in the section [[Shrinking the database>>https://learn.microsoft.com/de-de/previous-versions/sql/sql-server-2008-r2/ms189275(v=sql.105)?redirectedfrom=MSDN) ]]. 
© Aagon GmbH 2025
Besuchen Sie unsere neue Aagon-Community