Skip to main content

SQL Database shrinking full step details with Screenshots to reduce database size



Step 1: (‎05-‎Mar-‎17 4:00:46 PM) User right click on "MicrosoftDynamicsAX (tree item)" in "Microsoft SQL Server Management Studio"
screenshot0001.JPEG




Step 2: (‎05-‎Mar-‎17 4:00:49 PM) User left click on "Properties (menu item)"
screenshot0002.JPEG




Step 3: (‎05-‎Mar-‎17 4:00:56 PM) User left click on "Options (tree item)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0003.JPEG




Step 4: (‎05-‎Mar-‎17 4:00:59 PM) User left click on "Auto Shrink ()" in "Database Properties - MicrosoftDynamicsAX"
screenshot0004.JPEG




Step 5: (‎05-‎Mar-‎17 4:01:00 PM) User left click on "Open (button)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0005.JPEG




Step 6: (‎05-‎Mar-‎17 4:01:02 PM) User left click on "containmentTypeComboBox (combo box)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0006.JPEG




Step 7: (‎05-‎Mar-‎17 4:01:03 PM) User left click on "Recovery model: (combo box)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0007.JPEG




Step 8: (‎05-‎Mar-‎17 4:01:04 PM) User left click on "Simple (list item)"
screenshot0008.JPEG




Step 9: (‎05-‎Mar-‎17 4:01:06 PM) User left double click on "Auto Shrink ()" in "Database Properties - MicrosoftDynamicsAX"
screenshot0009.JPEG




Step 10: (‎05-‎Mar-‎17 4:01:08 PM) User left double click on "Auto Shrink (edit)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0010.JPEG




Step 11: (‎05-‎Mar-‎17 4:01:09 PM) User left click on "OK (button)" in "Database Properties - MicrosoftDynamicsAX"
screenshot0011.JPEG




Step 12: (‎05-‎Mar-‎17 4:01:11 PM) User right click on "MicrosoftDynamicsAX (tree item)" in "Microsoft SQL Server Management Studio"
screenshot0012.JPEG




Step 13: (‎05-‎Mar-‎17 4:01:12 PM) User left click on "Tasks (menu item)"
screenshot0013.JPEG




Step 14: (‎05-‎Mar-‎17 4:01:13 PM) User left click on "TasksDropDown (menu)"
screenshot0014.JPEG




Step 15: (‎05-‎Mar-‎17 4:01:14 PM) User left click on "ShrinkDropDown (menu)"
screenshot0015.JPEG




Step 16: (‎05-‎Mar-‎17 4:01:17 PM) User left click on "OK (button)" in "Shrink File - MicrosoftDynamicsAX"
screenshot0016.JPEG




Step 17: (‎05-‎Mar-‎17 4:01:47 PM) User left click on "Empty file by migrating the data to other files in the same filegroup (radio button)" in "Shrink File - MicrosoftDynamicsAX"
screenshot0017.JPEG




Step 18: (‎05-‎Mar-‎17 4:01:51 PM) User right click on "MicrosoftDynamicsAX (tree item)" in "Microsoft SQL Server Management Studio"
screenshot0018.JPEG




Step 19: (‎05-‎Mar-‎17 4:01:53 PM) User left click on "Tasks (menu item)"
screenshot0019.JPEG




Step 20: (‎05-‎Mar-‎17 4:01:54 PM) User left click on "TasksDropDown (menu)"
screenshot0020.JPEG
Step 21: (‎05-‎Mar-‎17 4:01:55 PM) User left click on "ShrinkDropDown (menu)"
screenshot0021.JPEG
Step 22: (‎05-‎Mar-‎17 4:01:56 PM) User left click on "File type (combo box)" in "Shrink File - MicrosoftDynamicsAX"
screenshot0022.JPEG




Step 23: (‎05-‎Mar-‎17 4:01:57 PM) User left click on "Log (list item)"
screenshot0023.JPEG
Step 24: (‎05-‎Mar-‎17 4:01:58 PM) User left click on "OK (button)" in "Shrink File - MicrosoftDynamicsAX_log"
screenshot0024.JPEG


Popular posts from this blog

Resolved : Power BI Report connection error during execution

Getting Below Power BI Report connection error during execution . Error: Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: Business Sector. Underlying error message: AnalysisServices: A connection cannot be made. Ensure that the server is running. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: AnalysisServices Microsoft.Data.Mashup.ValueError.DataSourcePath: 10.10.10.60;T_CustomerMaster_ST Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: c72c4f12-8c27-475f-b576-a539dd81826a Request ID: dfb54166-c78f-4b40-779f-e8922a6687ad Time: 2019-09-26 10:03:29Z Solution: We found report connection not able to connect to SQL Analysis service so tried below option. Re

Song- Khamoshiyan Piano keyboard Chord,Notation and songs Lyrics

All songs notation and chords at one place

Song : O Saathi Re Film : Mukhathar Ka Sikkandhar Uses : C D D# E G A Note : The numbers at the end of the lines indicate line numbers. Pallavi: O saathi re, tere binaa bhi kya jina, tere binaa bhi kya jina A- C D D#....,D D C DD E...C..CA-...,D D C DD E...CC.......1 Play line 1 again phulon men khaliyon men sapnom ki galiyon men GGG...GAGE.. GGG G A G E.................................................2 tere bina kuchh kahin naa E A G E D C D D#.......................................................................3 tere binaa bhi kya jina, tere binaa bhi kya jina D D C DD E....C..CA-..., D D C DDE....CC.............................4 Charanam: har dhadkan men, pyaas hai teri, sanson men teri khushboo hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................5 is dharthi se, us ambar tak, meri nazar men tu hi tu hai CCC C D C A-, CCC C D C A-, DDD DED CD EE.. CCCC......................6 pyaar yeh tute naa GGG... GAG D#......E.........................