Solved

SQL2012 - Sharepoint Config Log File Size

Posted on 2014-10-09
2
393 Views
Last Modified: 2014-10-21
Hi,
I have a client that is running a SharePoint database on a server2008r2. Sql is 2012.
The Sharepoint_Config transaction log file ldf is huge (120gb). The mdf file is only 200mb.

I have been researching the shrink file command, or shrink file via the SQL Server management Studio.
 I have ran a 'DBCC SQLPERF(logspace)' and the Log file space used  is only 2.7 % on this database.

Can anyone advise me this is safe to do? and is there anything I need to do before running shrinkfile on the ldf file? except taking a full backup of the database.

Thanks, Colin
0
Comment
Question by:VitalNetworkSolutions
2 Comments
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points
ID: 40370815
It's safe to shrink it. This Log file bloat is quite common.

There are the below methods, or DBCC Shrinkfile...

http://www.inetnj.com/?page_id=305

http://shareyourpoint.wordpress.com/2013/03/22/how-to-manage-large-sharepoint-configuration-database-logfile/
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40372044
If you have not run any Transaction Log backups, you will not be able to shrink the Transaction Log.  What I suggest:
1. Start doing frequent Transaction Log backups or if you are unable to do that then
2. Change the Recovery Model from Full to Simple and lose the ability to do point-in-time restores.

Only do a DBCC SHRINKFILE as a last resort as it is detrimental to the health of your Transaction Log and therefore your database.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Application Crash 2 23
Help in Bulk Insert 9 34
SQL Syntax: How to force case sensitive query? 2 30
Rename a column in the output 3 14
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question