Skip to main content

Issues with Transaction Logs

After adding a Security Certificate to our SharePoint server, we had an issue with the transaction log for the content database exploding exponentially taking up most of the remaining space on our SQL server.

The site slowed down to a crawl and it was quick to see that this was a problem that needed immediate assistance.

I knew it was possible to shrink an SQL database, but not having an SQL server background, I wasn't sure what implications that would have for our SharePoint system. So I did some research on TechNet and found instructions on how to do it. Then I contacted a DBA friend and started asking questions. I was pretty sure that I could write a job in the SQL Studio Manager to shrink the database and transaction log, but was an honest with my manager that I didn't know what repercussions it would cause. Thus we opted to call in a consultant.

Turns out the consultant did exactly what I had found to do. We ran the shrink on the main content database without a problem, this cleared up the transaction log size as well.

Two weeks later we had the same issue on the Admin Content database. So I went intot he SQL Studio and wrote the job and cleared that up myself.

Every day is a learning experience with SharePoint. The more I learn, the more I realize there is to learn.

Comments

Popular posts from this blog

Creating a SharePoint blog post using Word 2010

Create your blog posts in Word 2010 and post to your SharePoint blog (or other blogs such as Blogger). It's really quite simple. Open Microsoft Word 2010. From the Start menu, Select NEW>Blog Post The first time you do this, you'll be asked to register your blog platform. Word provides several options. I selected Blogger (of course). Provide your account # and password: Then you'll be asked to provide Picture Options... provide your server location or choose None. (see this page from Microsoft for more details on the Picture Options: http://office.microsoft.com/en-us/word-help/help-with-blogging-in-word-HA010164021.aspx?ver=14&app=winword.exe#_Toc321212396 ) ) Type your blog post as normal, inserting pictures if desired and publish. This Microsoft Video shows you how: http://office.microsoft.com/en-us/sharepoint-server-help/video-use-word-2010-to-post-to-a-sharepoint-blog-VA101790488.aspx
Creating and applying a Composed Look: 1. Download SharePoint Designer 2013 and SharePoint Color Palette Tool. 2. Create your theme using the SharePoint Color Palette Tool and save it as a .spcolor file. Suggest that you sort the Color Slot Grouping by UI Groups. 3. Open SharePoint Designer 2013. 4. Click Open Site. 5. Enter the URL of your SharePoint page (Master Page). 6. Click on All Files under Navigation. 7. Click on _catalogs. 8. Click on theme. 9. Click on 15. 10. Click Import Files. 11. Select your .spcolor file and click ok. You should now see your template file in the 15 directory. 12. Click All Files. 13. Click images. 14. Click Import Files. 15. Select the image you want for your background image and click ok. You should now see your image file in the image directory. 16. Now open the master page that you want to add the theme to in SharePoint 2013. 17. Click on the settings icon and select Site Settings. 18. Under Web Designer Galle...