Large SharePoint Database LDF File and 14 Hive Logs



.ldf files


Some Times we find that the .ldf files (log files) of our SharePoint Database are bigger in size than that of the .mdf(Data files) file.
Now in this case if the logs are not required it can be easily shrinked.
It depends if the server is running smooth and we may not require the logs or if its a development environment and you are sure you can remove unwanted logs.

 Generally its a good practise if we take a backup of the ldf to some other system and then shrink the file.
For SQL Server 2008, the command is:
ALTER DATABASE WSSContent SET RECOVERY SIMPLE
DBCC SHRINKFILE('WSSContent', 0, TRUNCATEONLY)



14 Hive Logs



Now same goes for the 14 hive logs of SharePoint they turn out to be of huge size in a span of time and many a times consume huge space which can be recovered.


C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS


You can safely delete the old files which are not required.


The Above two methods can give you huge amount of space if on the server.


























































Comments









  1. VishalMay 8, 2014 at 4:03 AM
    Hi Saga 
    My developement environment is running out of space
    For sql server 2005 i used below script

    USE ["Database Name"]
        GO
        ALTER DATABASE ["Database Name"] SET RECOVERY SIMPLE
        GO
        backup log ["Database Name"] with truncate_only
        GO
        DBCC SHRINKFILE (["Log File Name"],1)
        GO
        ALTER DATABASE ["Database Name"] SET RECOVERY FULL
        GO

    It resolved my issue

    Thanks for the help 
    ReplyDelete
    Replies
    1. Saga PandaMay 11, 2014 at 1:06 AM
      Hey Vishal,
      Thanks for your update on SQL Server 2005.
      Its always better to specify the database name and reset the recovery mode to full.
      Hope this will be helpful to many.
      Delete
  2. UnknownJuly 8, 2014 at 3:14 AM
    Hi Saga,

    please let me know if this can be used for production server.
    Successfully done on UAT environment.

    Thanks for your Help.
    ReplyDelete











Post a Comment































Popular posts from this blog









Install Node.js without admin rights





















  Hi Folks,   This is a copy paste version of one of the blogs which helped me.Giving due to credit to him.Just wanted a copy of the same with some minor updates.Below is the link for reference   http://abdelraoof.com/blog/2014/11/11/install-nodejs-without-admin-rights/     Step 1: Get Node.exe   First you will need to download the Windows Binary. You can get it from  Node.js download page  or  http://nodejs.org/dist/latest/ . For x64, you will have to download from the appropriate folder. Move the executable to a local folder.   Step 2: Get NPM   NPM (Node Package Manager) is the package manager for Node.js and you will need this for your development. You can download NPM from  https://github.com/npm/npm/releases  and extract the zip file to a local folder.   Step 3: Copy the extracted files in a folder   Copy npm.cmd from extracted folder  \npm\bin to the folder where node.exe resides   Now move the extracted npm files in a folder named "node_modules\npm" in the same folder








Read more










Create a lean React Solution using Typescript





















 Make sure you have node and npm installed Directory Setup 1. npm run init 2. create public and src folder 3. Add index.html in public folder 4. Add index.tsx in src folder Add Dependencies npm install react react-dom Add Dev Dependencies npm install typescript webpack webpack-cli webpack-dev-server ts-loader html-webpack-plugin  --save-dev  npm i --save-dev @types/react-dom typed-scss-modules  Add Configuration and Code Add code to src\index.tsx https://github.com/sagarpandey88/templates/blob/main/typescript-react/src/index.tsx Add webpack.config.js https://github.com/sagarpandey88/templates/blob/main/typescript-react/webpack.config.js Add tsconfig.json https://github.com/sagarpandey88/templates/blob/main/typescript-react/tsconfig.json Run the code npm run build npm run start








Read more










Replace all occurence of String in JavaScript





















 Hi All,   I came across an issue in JavaScript where i was not able to replace all the occurrences of a string in another string.   A simple string.replace would only replace the first occurence.   str.replace("hello", 'hi');   We can make a small tweak in the existing code and make it work.Below is an example.  str.replace(new RegExp('hello', 'g'), 'hi');   








Read more