Changes for page Datenbankmanagement

Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.jklein
	1	+XWiki.SV

Content

...	...	@@ -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
...	...	@@ -68,8 +68,7 @@
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. 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) ]].