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)
Why do we use np.random.seed()
This is a simple function but to my surprise lot of ML engineers had asked me about the actual usage of this function and why do I use it wh...
-
Note : In below scenario jenkins was deployed in Linux container Scenario: Jenkins build failed with error. java.io.IOException: error... -
error during connect: Post http://%2F%2F.%2Fpipe%2Fdocker_engine/v1.40/auth: open //./pipe/docker_engine: The system cannot find the file ... -
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...
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