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)
Profile not found. Tried ~/.bashrc, ~/.bash_profile, ~/.zshrc, and ~/.profile.
Error when installing NPM Profile not found. Tried ~/.bashrc, ~/.bash_profile, ~/.zshrc, and ~/.profile. Fix: Run command and try a...
-
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... -
Am sure lot's of people would be wondering how to hide menu items of a list eg document libraries "Send to " menu item . In o... -
API manager showing up as "Unregistered " even after publishing the API to cloudhub Check out the setting of clientid and s...
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