Changes for page Datenbankmanagement

Summary

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

Details

Page properties

Author

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

Content

...	...	@@ -36,7 +36,8 @@
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		-[[image:66_Datenbank_Datenbank verkleinern_690.png||data-xwiki-image-style-alignment="center"]]
	39	+(% style="text-align:center" %)
	40	+[[image:66_Datenbank_Datenbank verkleinern_690.png]]
40	40
41	41	{{figureCaption}}
42	42	Shrink database
...	...	@@ -61,13 +61,14 @@
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="HDatenbankverkleinern"]] option.
	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.
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//.
68	68
69	69	{{figure}}
70		-[[image:66_Datenbank_Datei verkleinern_690.png||data-xwiki-image-style-alignment="center"]]
	71	+(% style="text-align:center" %)
	72	+[[image:66_Datenbank_Datei verkleinern_690.png]]
71	71
72	72	{{figureCaption}}
73	73	Reducing the size of files
...	...	@@ -117,7 +117,8 @@
117	117	Executions Right click on the ACMP Database and select //New Query// from the context menu that opens.
118	118
119	119	{{figure}}
120		-[[image:66_Datenbank_Aufruf einer neuen Abfrage_478.png||data-xwiki-image-style-alignment="center"]]
	122	+(% style="text-align:center" %)
	123	+[[image:66_Datenbank_Aufruf einer neuen Abfrage_478.png]]
121	121
122	122	{{figureCaption}}
123	123	Insert new query
...	...	@@ -132,7 +132,8 @@
132	132	##EXEC ap_index_defrag 0,0##
133	133
134	134	{{figure}}
135		-[[image:66_Datenbank_Ausführung einer neuen Abfrage_837.png||data-xwiki-image-style-alignment="center"]]
	138	+(% style="text-align:center" %)
	139	+[[image:66_Datenbank_Ausführung einer neuen Abfrage_837.png]]
136	136
137	137	{{figureCaption}}
138	138	Execute query SQL script in query
...	...	@@ -175,7 +175,8 @@
175	175	If "Full" or "Bulk logged" is set in the drop-down field, change the entry to "Simple".
176	176
177	177	{{figure}}
178		-[[image:66_Datenbank_Datenbankeigenschaften_698.png||data-xwiki-image-style-alignment="center"]]
	182	+(% style="text-align:center" %)
	183	+[[image:66_Datenbank_Datenbankeigenschaften_698.png]]
179	179
180	180	{{figureCaption}}
181	181	Customize recovery model
...	...	@@ -184,4 +184,4 @@
184	184
185	185	Then click //OK// and the window will close.
186	186
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) ]].
	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"]].