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

Make your SharePoint Libraries Favorites in Windows Explorer for Easier Saving

You're working furiously on a document with only a few minutes left until the doors close for the day (or your laptop battery dies, or some other emergency happens). You need to save the document to SharePoint, but you can't remember where the document library is in which you need to save the document.  If you make your frequently used Document Libraries Favorites in Windows Explorer.  That won’t be a problem again! Here's how to make it easier to save your documents to your SharePoint library: Create a Favorite in Windows Explorer.  Not in your browser (Internet Explorer, Chrome, Firefox, etc.). Let me show you what I mean: Figure 1: Windows Explorer Favorites So how did I get this screen? And how did I put the Shared Documents folder in my Favorites? This blog post will answer those questions. How to Get to the Favorites in Windows Explorer: I’m using Windows 7, so if you’re running XP, Vista, or Win8, your screen may lo...
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...

InfoPath Would Not Submit a Form - Concatenate function yielded a title that was too long!

Had a user today who was experiencing issues submitting an InfoPath form.  The original set of error messages made me assume that SharePoint was not set as Local Intranet site (which it wasn't).  So I set SharePoint as the local intranet site,  updated the user's desktop icon shortcut (to use the https version of the site).  And thought, okay, problem solved.  Alas and alack, not so! The user entered a form went to submit it and got a different set of error messages. (Unfortunately I didn't think to screenshot the errors and send them to myself so I don't have the exact wording for any of the errors.)  The basic message the second time was InfoPath cannot submit the form.  I've seen variations of this error before, so I started looking at Compatibility View, and Add-ons.  Well, I found the user had IE10 which we recommend our users NOT install as there are known compatibility issues with IE10 and SharePoint 2007 as well as some of our other inte...