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

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...

A review of VisualSP for SharePoint 2013 - unsolicited

One of the things we wanted to do in our new SharePoint 2013 environment was create a more user friendly environment and increase adoption by giving users the ability to learn "how-tos" without the need of a training class or a guided tour by the SharePoint person (aka me). My first thought when we began planning for the upgrade was that built-in help would be excellent, but would also be a monumental task to create. Having used many of SharePoint-Videos.com videos for my own learning needs, I turned to their site for ideas. Enter VisualSP. Obviously, I'm not the only person who desired in-context help for the end users. We purchased VisualSP for SharePoint 2013. Once our environment was configured properly, installation was not difficult. The installation procedures were straight forward and easy to follow. I am not replicating that information here, but will hit the highlights. For full details and screenshots, see the link above. Installation must...

Robin's SharePoint and Website musings

Search This Blog