In my case the SharePoint Config DB log size became 35 GB which ate up all the disk space nearly crashing the system . This is a development machine so disk space was limited to 50 GB .
Did some search and the below steps solved the issue. The steps given below is not recommended to be implemeted in production , only in development / QA machine in order to save some resource .
1) Right click on you DB -> Properties
2)Select Options
3) Change the Recovery Model to SIMPLE and Click Ok
Once that is done ,
-Right click on DB -> Tasks - > Shrink -> Files
- In File type select log and click OK
My Config DB Log files were reduced from 35 GB - > 504 KB
Note : Simple recovery model is not suggested for Production Systems
Subscribe to:
Post Comments (Atom)
Tranformation in Manufacturing
Do you want to know how CPG industry is undergoing transformation using IoT technology, read the blogs on how AWS partners are using AWS t...
-
Note : In below scenario jenkins was deployed in Linux container Scenario: Jenkins build failed with error. java.io.IOException: error...
-
Ever wanted to have a people picker kind of control in Infopath form and that too in browser mode. Did i heard yes :) , well there is a Acti...
-
Error when installing NPM Profile not found. Tried ~/.bashrc, ~/.bash_profile, ~/.zshrc, and ~/.profile. Fix: Run command and try a...
1 comment:
My config log file on production server is 122GB. To get it back under control can I set it to Simplerecovery mode, backup the db. Set initial size and growth to appropriate size then set back to full recovery?
Post a Comment